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 are the differences between blob and clob in oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What happens to the current transaction if the session is killed?
What is a snapshot log?
How to delete all rows a table in oracle?
What happens to indexes if you drop a table?
How to write date and time interval literals in oracle?
what is the difference between restoring and recovering?
what is the scenario where you take the database to NoArchivelog mode?
What is a static data dictionary in oracle?
Is truncate autocommit in oracle?
How many categories of data types in oracle?
Why is oracle so popular?
What is a dynamic performance view in oracle?
How to loop through a cursor variable?
