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
How do I partition a table in sql?
what are the advantages a stored procedure? : Sql dba
What is a procedure in pl sql?
What does closing a cursor do?
What is difference between stored function and application function?
Can a foreign key be a duplicate?
What are the constraints available in sql?
What is rownum and rowid?
Can a commit statement be executed as part of a trigger?
How do I quit sql?
what is 'mysqlimport'? : Sql dba
Can we use rowid as primary key?
What are the limitations of sql express?
how do you login to mysql using unix shell? : Sql dba
What is on delete restrict?