What are the advantages of VIEW?

Answer Posted / anil_abbireddy

1. data security : complex view can not be modified ie.
base tables cannot be visible.
2. it provides easy way to query data from different data
sources like a single table
3.it is very usefull when developing complex reports basing
on multiple tables.

Is This Answer Correct ?    38 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bitemporal narrowing?

735


How do I sort a table in sql?

595


What is not null in sql?

573


How to call a javascript function from pl sql?

561


What is sql*loader and what is it used for?

579






Does truncate require commit?

542


How do I view an execution plan in sql?

527


How to order siblings in oracle hierarchy queries?

598


Is oracel sql developer written in java?

647


Why do we use procedures?

516


How do I view a view in sql?

506


I need a function for a train ticket reservation please answer it thanks in advance

561


What steps server process has to take to execute an update statement?

506


Inline the values in PL/SQL, what does it mean.?

627


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

595