Create View « View « Oracle PL / SQL






  1. Oracle PL / SQL
  2. View
  3. Create View
1.Create or replace a view
2.Create view without indiating the column name
3.Create OR REPLACE VIEW from selected columns in a table
4.Create a simple view
5.create force view
6.create materialized view
7.Create a view with check option
8.Create view by join three tables
9.Create view on single field of a type




10.Using view to simplify the query
11.User view and object id
12.Use view based on user-defind type