- Create Simple View with Selected columns of a table
- Create a View with all columns of a table
- Create view with columns from multiple tables
- Modify the View definition - create or replace
- Update view rows -
- Non Updatable views – A view with distinct, group by, aggregate functions cannot be updated. Row manipulation is not possible for the underling tables for these tables.
- Create View without base table using FORCE clause. The view will be created with compilation errors.
- To describe the structure of the view
- To drop a view