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 cognitive schema?
What are the general rules on data consistency?
How does the on-delete-cascade statement work?
How to generate query output in html format?
How to delete a column in an existing table?
What is the string concatenation operator in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What are nested tables?
Explain user account with reference to oracle.
How to delete a user account in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is a initialization parameter file in oracle?
What is a sub query and what are the different types of subqueries?
What are the different oracle database objects?