Purpose of view in oracle

<<Previous  Next>>

Oracle - Describe the purpose of view in oracle - April 10, 2009 at 11:00 AM

Describe the purpose of view in oracle  

The purpose of views is defined below.

Views hide data complexity.
Views add security by restricting access to the columns of a table.
Views simplify queries for the user.
It is way to isolate application from changes in definitions of base tables.

Also read

Difference between a View and Materialized View

View is created joining a single or multiple tables. It is an abstract of the data distributed in different tables...........

Oracle views

What is the content view and stacked view?, Explain the different types of canvas views, Explain the significance of OR REPLACE, FORCE and NOFORCE while creating view.............

Explain how to view existing locks on the database.

A number of data locks need to be monitored, in order to maintain a good performance level for all sessions, along with the time for which they last............. 

<<Previous  Next>>

Write your comment - Share Knowledge and Experience