Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / View

 

Views

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.