What are the advantages of Views ?
Answers were Sorted based on User's Feedback
Answer / guest
The advantages of views are
1)Data abstraction
2)Simple retrieving of data.
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / nishi
- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ven
secutiry of the data for ex: in bank domain some of the
columns data don't want to see others then we can restrict
the columns and create views and share the columns
whichever others can see.
| Is This Answer Correct ? | 2 Yes | 3 No |
difference between oracle8i and oracle9i
how to create a new database in oracle?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
what is the syntax of UPDATE command?
What privilege is needed for a user to create indexes in oracle?
What is dynamic proxy?
How to empty your oracle recycle bin?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to retrieve values from data fields in record variables?
How to connect ms access to oracle servers?
What is oracle sid?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>