Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amadur
If we have several tables in a DB and we want to view only
specific columns from specific tables we can go for
views.It would also suffice the needs of security sometimes
allowing specific users to see only specific columns based
on the permission that we can configure on the view. Views
also reduce the effort that is required for writing queries
to access specific columns every time
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain integrity constraints?
master table and child table performances and comparisons in Oracle ?
How are extents allocated to a segment?
What is oracle database client?
What are a query and state the different types of queries and their uses?
Is it possible to split the print reviewer into more than one region ?
How to create a new tablespace in oracle?
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 calculate date and time differences in oracle?
What are the different types of trigger and explain its various uses and functions?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What are the system predefined user roles?
WHAT IS ecc 6.0
What are temporal data types in oracle?
What are the differences between char and varchar2 in oracle?
