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
What is relationship? How many types of relationship are there?
What is sqlexception in java?
What is cartesian join in sql?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is file based approach?
what happens if null values are involved in expressions? : Sql dba
how to calculate expressions with sql statements? : Sql dba
What is %type in sql?
What is compiled query?
What is the difference between sql and isql*plus?
What is data type in sql?
What is sqlcommand?
How do I delete a trigger?
What are the different sql languages?
What is procedure and function in sql?