Difference between revisions of "View"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
** Only definition (query) of the view is stored | ** Only definition (query) of the view is stored | ||
** the data is retrieved from the underlying table based on the view definition | ** the data is retrieved from the underlying table based on the view definition | ||
CREATE VIEW customer_south AS | |||
SELECT customer_id, first_name, region | |||
FROM customer | |||
WHERE lower(region) = 'south' | |||
[[#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:51, 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
CREATE VIEW customer_south AS SELECT customer_id, first_name, region FROM customer WHERE lower(region) = 'south'