Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to delete a column in an existing table in oracle?
What is an oracle database table?
How many types of tables supported by oracle?
How to assign values to variables?
How would you change old and new values in an insert, delete and update triggers?
How to pass a cursor variable to a procedure?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to write an inner join with the where clause in oracle?
How to load a large xml file?
How to create a single index for multiple columns?
candidate key is subset of super key but not vice-verse explain
How to rebuild an index in oracle?
How to sort output in descending order in oracle?
What are the uses of a database trigger?
In what script is snap$ created? In what script is the scott/tiger schema created?
