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
Can we store pictures in the database and if so, how it can be done?
how to do daily transactions with out sql* loader control file regesterd in apps?
does the query needs a hint to access a materialized view?
Explain the use of indexes option in exp command.
Can we write insert statement in function in oracle?
What is connection pooling in oracle?
Explain oracle instance.
How to recover a dropped table in oracle?
What are privileges and grants?
What is difference between sid and service name in oracle?
What is an oracle wallet?
How to define a data field as not null?
What privilege is needed for a user to insert rows to tables in another schema?
How to concatenate two text values in oracle?
What is an oracle cursor variable?
