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 |
what is the difference between data migration and production migration.
How do you tell what your machine name is and what is its IP address?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
Please explain drop constraint oracle?
waht is the difference between primary key and super key?
What is the exact use of Collections?
Explain constraining triggers.
How to get last row id?
Can select statements be used on views in oracle?
How do I uninstall oracle client from windows?
What happens if you set the sga too low in oracle?
What is currency type in database ?