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
how to convert numeric values to character strings? : Sql dba
How to create a menu in sqlplus or pl/sql?
Why query optimization is needed?
What is not equal in sql?
How do I find sql profiler?
what is oltp (online transaction processing)? : Sql dba
What are crud methods?
What is cursor in pl sql with examples?
Explain mutating table error.
What are the types of views in sql?
What schema means?
What do you mean by rowid?
What is string join?
What is nosql vs sql?
Define implicit and explicit cursors.