what are views?

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


Please Help Members By Posting Answers For Below Questions

What is a snapshot in oracle database?

544


what is the dual table in oracle?

522


What is Trigger in Oracle?

549


What is a connect identifier?

525


What is a package in oracle?

538






Which are the five query types available in oracle?

500


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?

1498


What is query image?

558


How to increment dates by 1 in oracle?

539


Explain compound trigger in oracle?

521


How to start an oracle instance?

552


what is the scenario where you take the database to NoArchivelog mode?

1802


Explain joins in oracle?

540


What is flashback in Oracle?

560


How to test null values?

652