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 |
How to start a new transaction in oracle?
Explain implicit cursor.
Is a rollback possible to any savepoint?
Explain joins in oracle?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
Explain the difference between a procedure and a function? What do you understand by those terms?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Explain overloading. Can functions be overloaded?
What is an Oracle index?
Can we call a trigger inside a function and function inside a trigger? Give example.
What is backup in Oracle?
What is a parameter file in oracle?