View

From rbachwiki
Revision as of 15:08, 14 November 2017 by Bacchas (talk | contribs)
Jump to navigation Jump to search
  • 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'

EXECUTE the VIEW

SELECT * FROM customer_south

this will run the view

MODIFY A VIEW

CREATE OR REPLACE VIEW customer_south AS
SELECT customer_id, first_name, country,region
FROM customer
WHERE lower(region) = 'south'

Back To Top- Home - Category