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
What is a snapshot in oracle database?
what is the dual table in oracle?
What is Trigger in Oracle?
What is a connect identifier?
What is a package in oracle?
Which are the five query types available in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is query image?
How to increment dates by 1 in oracle?
Explain compound trigger in oracle?
How to start an oracle instance?
what is the scenario where you take the database to NoArchivelog mode?
Explain joins in oracle?
What is flashback in Oracle?
How to test null values?