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 are the advantages of running a database in archive log mode?
What is the use of aggregate functions in oracle?
What are the parameters that we can pass through a stored procedure?
What are temporal data types in oracle?
What is oracle open database communication (odbc)?
Difference between pre-select and pre-query
What is tns entry?
Explain the difference between sap and oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the differences between date and timestamp in oracle?
What is the Tune Query
What are the oracle built-in data types?
WHAT IS ecc 6.0
How to convert numbers to characters in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
