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
if you ctreate table identity
What is the difference between sharding and replication?
Is it possible to split the print reviewer into more than one region ?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What are the set operators union, union all, minus & intersect meant to do?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is oracle instant client?
Calculate difference between 2 date / times in oracle sql?
Is oracle the best database?
What is Data Dictionary Cache in Oracle?
How to use "in out" parameter properly?
What is meant by raw datatype?
How to convert times to characters in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Write a syntax for update query in oracle?