Answer Posted / ab
View do not contain data.
when u query view it featches the data from the underlaying
table on which view is created.
v$ views are created in X$ base tables
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is SQL access advisor in Oracle?
Can a formula column referred to columns in higher group ?
What is the exact use of Collections?
IS it possible to built the oracle database without setting the kernal parameters?
What is an oracle tablespace?
How to establish administrator authentication to the server?
How to display row numbers with the records?
What is recovery manager in Oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What are the differences between primary key and unique key?
material view and view disadvantages?
What is save point in oracle database?
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.
Where do you use decode and case statements?