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