Answer Posted / akn
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 ? | 6 Yes | 5 No |
Post New Answer View All Answers
How to update values on multiple rows in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are the various types of snapshots ?
Why is oracle used?
How many data types are supported?
What are advantages of dateset in datastage?
Respected sir, Please send me technical questions related to oracle apps..
What is a cursor variable?
What is bulk collect in oracle?
What is a procedure in oracle?
Can multiple columns be used in group by in oracle?
what is the difference between functional dependecy and multilevel dependency?
How does the on-delete-cascade statement work?
What are the logical operations?
How to run the anonymous block again?