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
What are the execution control statements in oracle?
Why should I use oracle database?
What is the maximum number of triggers that can be applied to a single table?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
State and explain the different types of data models?
What the is the diff between local index and global index. give some example.
What is a database schema in oracle?
How do you tell what your machine name is and what is its IP address?
What is proxy method?
What happens if the update subquery returns multiple rows?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What are the different oracle database objects?
What is oracle in java?
What are temporal data types in oracle?
How do I start tns listener?