Using SQL, you can define views, which are alternative representations of data from one or more tables.
A view is a derived table or a subset of the columns and rows of the table on which it is defined. A view can also be defined on another view.
The capability of joining two or more tables easily is a major advantage that distinguishes relational systems from nonrelational systems. The ability to create views, or derived tables, allows you to access and manipulate only that data which is significant for your purposes.
|
Copyright © 2014 CA.
All rights reserved.
|
|