Difference between revisions of "View"
Jump to navigation
Jump to search
(Created page with "* A view is the representation of a S Back To Top- Home - Category") |
|||
| Line 1: | Line 1: | ||
* A view is the representation of a | * A view is the representation of a SQL statement that is stored in memory so that it can easily be re-used | ||
** A view gives a view of the table as defined by the select statement in the view defination | |||
** View does not store data separately | |||
** Only definition (query) of the view is stored | |||
** the data is retrieved from the underlying table based on the view definition | |||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Revision as of 14:40, 14 November 2017
- A view is the representation of a SQL statement that is stored in memory so that it can easily be re-used
- A view gives a view of the table as defined by the select statement in the view defination
- View does not store data separately
- Only definition (query) of the view is stored
- the data is retrieved from the underlying table based on the view definition