Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pavan_1981
view is one type of database object which doesnt store any
data but fetches its data from the tables on which the view
is built.views can be of two types.one complex and other
simple.depending on type of te view different perations are
allowed on the views.
advatages:
1.views are secure because we can fetch the data from
different tables and present it to the user with cloumn
alias's so tha user wont know the actual column names or
table names.
2.instead of writing a huge join query which u most
frequently use everytime and executing it, we can create a
view using that query and just say for example "select *
from view".this inturn fetches the data u want from the
tables meeting ur requirements.
3.u can grant privilages to the user on the views instead
of giving privilages on the actual tables.this sometimes
help in security.
these are just few advantages to bgin with.still more exist.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What to do if the binary spfile is wrong for the default instance?
Briefly explain what is literal? Give an example where it can be used?
What is a initialization parameter file in oracle?
What is a parameter file in oracle?
How to define an external table with a text file?
What is the usage of merge statement?
What is the relation of a user account and a schema in oracle?
Explain the difference between sql and oracle?
Difference between open_form and call_form in oracle.
How to run create database statement again?
What is the difference between substr & instr functions?
How to select all columns of all rows from a table in oracle?
Why use resource manager in Oracle?
What privilege is needed for a user to create indexes in oracle?
Which is better Oracle or MS SQL? Why?
