What are the advantages of VIEW ?

To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations.

Interview Candidate
Sep 7th, 2004
1
2093

SQL Plus

Answer

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

SaratKumar Puranam

Oct 4th, 2005

Advantages of view:
1. Restricts the access to particular columns and rows of the base tables.
2. Hide the data complexity.
3. Can access the data for two different base tables with out performing a join.
4. Can display the data in different form from the base tables.(i.e. In the column names can can be changed with effecting the column names of the base tables).