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 Remove the 3rd highest salary person record from table?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
difference between procedures and function?
How to invoke the data pump export utility?
What is oracle open database communication (odbc)?
How to get a list of all background sessions in the database?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
Can I create users through internet explorer in oracle 10g?
Explain cascading triggers.
How do we create privileges in oracle?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What are the parameters that we can pass through a stored procedure?