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 |
Is the After report trigger fired if the report execution fails ?
Explain the use of online redo log files in oracle.
What is a Data Dictionary ?
Can we convert a date to char in oracle and if so, what would be the syntax?
What the is the diff between local index and global index. give some example.
what is the syntax of UPDATE command?
can any one help me with import/export options in oracle............
In which language oracle has been developed?
Is insert autocommit in oracle?
How would you begin to troubleshoot an ORA-3113 error?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
How to define a procedure inside another procedure?