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
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to write date and time interval literals in oracle?
How to count groups returned with the group by clause in oracle?
Explain an integrity constrains?
What are the limitations oracle database 10g xe?
Query to retrieve record for a many to many relationship ?
What is a proxy class?
How to use like conditions in oracle?
How to invoke the data pump export utility?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What do you mean by merge in oracle and how can we merge two tables?
How to list all indexes in your schema?
How to use regular expression in pattern match conditions in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
What are the benefits of ordbms?
