Define 'view' advantage ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / deva
view is the window for the data stored in the table(s). It
is the pointer to the data, will not store any data with in it.
more secure to the unauthorized data.
Time complexity reduces when we are accessing the data.
| Is This Answer Correct ? | 4 Yes | 1 No |
What is Row Chaining ?
How do I call oracle stored procedures that take no parameters?
How can Oracle users be audited?
What are main difference between Stored Procedure and Functions.
What are the differences between date and timestamp in oracle?
How to define an anonymous block?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
What are the various oracle database objects?
Is insert autocommit in oracle?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How to start a new transaction in oracle?