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
Show how functions and procedures are called in a pl/sql block.
What is a .db file?
What is mutating error?
explain advantages of innodb over myisam. : Sql dba
What is procedure and function in sql?
Why do we use triggers?
How many types of relationship are there?
Do we need to create index on primary key?
How do I create an index in word?
How do you use a while loop in pl sql?
What will you get by the cursor attribute sql%found?
How does sql store data?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
what does the t-sql command ident_incr does? : Transact sql
What is the use of pl/sql table?