Answer Posted / vinay dixit
please find the advantages as given below :-
a) data security - no need to give permission on the table,
infact a view can be created, having only selected number
of coloums in its definition. So user will only be able to
see those coloums.
b) simplicity - a very complicated query can be saved as a
view defenition. when needed can be called by its view name.
c) removes dependency - Can be very helpful to remove the
dependecny from the underlying tables. Suppose a view is
created by joining several tables. After some time, there
are some changes on the tables, so only defenition of view
can be changed and there is no need to change all the code
where view is used.
d) No space - takes no space ( except materialized view )
| Is This Answer Correct ? | 61 Yes | 4 No |
Post New Answer View All Answers
What are the dml statements?
How can the performance of a trigger be improved?
What is varchar used for?
What is coalesce sql?
What is mutating sql table?
What is the difference between instead of trigger and after trigger?
what is user defined functions? : Sql dba
How do I start pl sql?
What is a pdo connection?
State some properties of relational databases?
can sql servers linked to other servers like oracle? : Sql dba
How do I pipe the output of one isql to another?
how to convert character strings to numeric values? : Sql dba
How do you write a complex sql query?
How to create a menu in sqlplus or pl/sql?
