Create View

Description: Basic syntax for creating a view.

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

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.