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 to convert character types to numeric types?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What are the execution control statements?
What is the relationship among database, tablespace and data file?
What is control file used for?
What is the scope of a local variable?
Is there a function to split a string in plsql?
Give the various rollback segment states.
What types of joins are used in writing subqueries?
Why do you create or replace procedures rather that drop and recreate.
What is difference between sid and service name in oracle?
material view and view disadvantages?
Describe an oracle table?
What happens to the current transaction if the session is ended?
How to use regular expression in pattern match conditions in oracle?