Oracle PL/SQL: Create View - Basic syntax for creating a view.

Quick Search:

Oracle PL/SQL: Create View

Jump to:

Snippet Name: Create View

Description: Basic syntax for creating a view.

Also see:
» Materialized View
» VIEW

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 02nd, 2009

CREATE OR REPLACE VIEW vtest AS
SELECT owner, table_name, column_name
FROM all_tab_columns;