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
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the various constraints used in oracle?
What is an oracle tablespace?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is logical backup in oracle?
What is the difference between a user and a schema in oracle?
How would you change old and new values in an insert, delete and update triggers?
What privilege is needed for a user to create views in oracle?
How oracle handles dead locks?
What is the difference between alert log file and tarce file ?
How to load excel data sheet to oracle database
How to get a list of all user accounts in the database?
How to create a server parameter file?
What is an oracle database table?
Explain alias?
