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
What is a directory object?
Explain the use of indexes option in exp command.
How do I spool in oracle?
How do I call oracle stored procedures that take no parameters?
What is data file?
Does oracle database need java?
What is meant by raw datatype?
What is recovery manager(rman) backup in Oracle?
How to define a specific record type?
What is a user role in oracle?
what are archived logs?
What is bulk load in oracle?
Give the constructs of a package, function or a procedure.
Define oracle database
What is the recommended interval at which to run statspack snapshots, and why?
