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
How to put more than 1000 values into an oracle in clause?
How to write a left outer join with the where clause in oracle?
How to use values from other tables in update statements using oracle?
How to select all columns of all rows from a table in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Design database draw er diagram for a certain scenario ?
What is oracle latest version?
How to start an oracle instance?