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
What is the difference between a user and a schema in oracle?
Write a trigger example in oracle?
What is oracle used for?
What is a synonym? What are its various types?
How do I uninstall oracle 11g?
Explain an integrity constrains?
Explain the characteristics of oracle dba?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Explain index?
is there a tool to trace queries, like profiler for sql server?
How to rename an existing table?
How to use existing values in update statements using oracle?
how to handle exceptions in post production
how may join possible between (requisition with purchase order)
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.