Create Or Change View. To add. CREATE VIEW defines a view of a query.
A view contains rows and columns just like a real table. View_name The name of the Oracle VIEW that you wish to create or replace. INSTEAD OF triggers defined on a conventional view are dropped when the view is re-created.
TBLPROPERTIES property_name property_value.
1 Creating a simple view example. Then do a CREATE VIEW or ALTER VIEW depending on the result. View_name The name of the Oracle VIEW that you wish to create or replace. Here is an example of how you would use the Oracle CREATE OR REPLACE VIEW Statement.