Quick Search:
 
 Oracle PL/SQL: VIEW Jump to:  
Category: >> Oracle PL/SQL >> VIEW  

<< lastnext >>

Snippet Name: 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.

Also see:
» Materialized View
» Create View

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

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


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org