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 would you begin to troubleshoot an ORA-3113 error?
Can multiple cursors being opened at the same time?
what is normalisation?what are its uses?
How do you bind variables in oracle?
How will you differentiate between varchar & varchar2?
What are the different types of modules in oracle forms?
How to use fetch statement in a loop?
How to save query output to a local file?
Give the various exception types.
What is where clause in oracle?
What is Java Pool in Oracle?
How to drop a stored procedure in oracle?
What is oracle database 10g express edition?
How to shutdown your 10g xe server from command line?
What is a named program unit?