Views : Create View « View « Oracle PL/SQL Tutorial






  1. A view is a predefined query on one or more tables.
  2. Retrieving information from a view is done in the same manner as retrieving from a table.
  3. With some views you can also perform DML operations (delete, insert, update) on the base tables.
  4. Views don't store data, they only access rows in the base tables.
  5. user_tables, user_sequences, and user_indexes are all views.
  6. View Only allows a user to retrieve data.
  7. view can hide the underlying base tables.
  8. By writing complex queries as a view, we can hide complexity from an end user.
  9. View only allows a user to access certain rows in the base tables.








8.1.Create View
8.1.1.Views
8.1.2.Creating and Using a View
8.1.3.Creating and Using Simple Views
8.1.4.Choose specific column from base table
8.1.5.Creating a View with a CHECK OPTION Constraint
8.1.6.Creating a View with a READ ONLY Constraint
8.1.7.Create view based on user-defined function
8.1.8.Create a view by joining two tables
8.1.9.Create view based on aggregate function
8.1.10.a user-defined type view
8.1.11.CREATE MATERIALIZED VIEW with TABLESPACE
8.1.12.CREATE MATERIALIZED VIEW with rowid
8.1.13.Create view by join three tables
8.1.14.Create view on single field of a type
8.1.15.create materialized view emp_dept build immediate refresh on demand enable query rewrite
8.1.16.Use view based on user-defind type