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 private synonym?
Explain an integrity constrains?
What happens to the current transaction if a ddl statement is executed?
What is a database table in oracle?
Explain about integrity constraint?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is an anonymous block?
What is background process in Oracle?
Which is better Oracle or MS SQL? Why?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How many types of table in Oracle?
How to call a stored function in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is data file?
What is pragma autonomous transaction in oracle?
