Oracle PL/SQL: VIEW - A view is a SQL statement stored in the database in the system tablespace. Data for a view is built

Quick Search:

Oracle PL/SQL: VIEW

Jump to:

Category: >> Oracle PL/SQL >> VIEW

<< last

next >>

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