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
How to store only time; not date and time?
What is raw datatype in oracle?
What is save point in oracle database?
What is a named program unit?
What is Java Pool in Oracle?
What is an Oracle index?
What happens if recursive calls get out of control?
How to change system global area (sga) in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What are the attributes of cursor?
How do I manually create a database in oracle?
How to unlock the sample user account in oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Explain the use of analyse option in exp command.
What happens if you set the sga too low in oracle?
