what are views?

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


Please Help Members By Posting Answers For Below Questions

Is there an oracle sql query that aggregates multiple rows into one row?

524


How to rename an existing table?

583


How to create a testing table in oracle?

519


What is a tns service name?

511


How many memory layers are in the oracle shared pool?

613






Can we store pictures in the database and if so, how it can be done?

562


How to use subqueries with the in operator using oracle?

586


What to do if dba lost the system password?

573


What types of joins are used in writing subqueries?

538


Explain about functional dependency and its relation with table design?

523


How to define a data field as not null?

608


How to filter out duplications in the returning rows using oracle?

610


How to load data from external tables to regular tables?

513


What is oracle and what are its different editions?

548


Differentiate between post-database commit and post-form commit?

516