View

Description: A view is a SQL statement stored in the database in the system tablespace. Data for a view is built in a table created by the database engine in the TEMP tablespace.

CREATE OR REPLACE VIEW test_v AS
SELECT owner, table_name
FROM all_tab_columns;
 
-- any valid sql statement can follow the create or
-- replace statement

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.