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
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to create a server parameter file?
Explain an index?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How does the on-delete-cascade statement work?
Explain the use of full option in exp command.
What is a sub query? Describe its types?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Briefly explain what is literal? Give an example where it can be used?
why dont we assign not null constraint as table level constraint.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is rowid and rownum in oracle?
Explain coalesce function?
Explain the use of owner option in exp command.
What are the most common interview questions on ETL Testing for experience?