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 |
How to bring a tablespace offline?
Which Oracle App Is Most Popular One ?
What is a subquery in oracle?
How to get execution statistics reports on query statements?
 What are the oracle DML commands possible through an update strategy?
How to drop an index in oracle?
What are the execution control statements?
How to create a new tablespace in oracle?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
What are the ansi data types supported in oracle?
when i run my query on yesterday it is fast but today it is slow why?
What are the differences between date and timestamp in oracle?