Answer Posted / o.nagamani
View is a virtual storage of the original table.It is the
one kind of data hiding.
Advantages of View:
1. Restrict Data Access and/or simplify data access.
2. Simplify Data manipulation.
3. Import and Export data.
4. Merge Data.
Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How oracle handles dead locks?
What is oracle rownum?
What are transaction isolation levels supported by oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is set operator oracle?
What is open database communication (odbc) in oracle?
How to list all tables in your schema?
What is an oracle function?
What is null value in oracle?
How to create a server parameter file?
How to use "in" parameter properly?
What is a package ? What are the advantages of package ?
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.