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

how to convert numeric values to character strings? : Sql dba

569


How to create a menu in sqlplus or pl/sql?

613


Why query optimization is needed?

521


What is not equal in sql?

511


How do I find sql profiler?

520






what is oltp (online transaction processing)? : Sql dba

536


What are crud methods?

553


What is cursor in pl sql with examples?

481


Explain mutating table error.

649


What are the types of views in sql?

542


What schema means?

527


What do you mean by rowid?

538


What is string join?

559


What is nosql vs sql?

569


Define implicit and explicit cursors.

631