What are the advantages of Views ?

Answer Posted / nishi

- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.

- Hide data complexity.

- Simplify commands for the user.

- Present the data in a different perspective from that of the base table.

- Store complex queries.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to bring a tablespace online?

522


How to assign query results to variables?

594


How to rollback the current transaction in oracle?

544


Describe the types of sub query?

561


Where do we use decode and case statements?

567






Can we connect to ORACLE db using Windows Authentication?

727


Differentiate between pre-select and pre-query?

627


How to drop a stored procedure in oracle?

592


What is a tns file?

504


Respected sir, Please send me technical questions related to oracle apps..

1385


Why packages are used in oracle?

547


What are the logical operations?

681


What are advantages of dateset in datastage?

1753


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1912


What is set verify off in oracle?

583