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 define an anonymous procedure without variables?

732


What are the general rules on data consistency?

749


Write a trigger example in oracle?

777


Explain the use of log option in exp command.

730


How can we find out the duplicate values in an oracle table?

811


How do I learn what codesets are available in oracle?

762


Explain the different normalization forms?

801


What is a system tablespace?

787


What is SQL Tuning Advisor in Oracle?

852


How do I know if oracle is installed on windows?

656


How to use "for" statements in oracle?

752


What is merge in oracle?

779


Why does for update in oracle 8 cause an ora-01002 error?

733


How to estimate disk space needed for an export job?

744


Difference between pre-select and pre-query

763