Do View contain Data ?

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


Please Help Members By Posting Answers For Below Questions

if you ctreate table identity

1861


What is the difference between sharding and replication?

493


Is it possible to split the print reviewer into more than one region ?

1845


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?

537


What are the set operators union, union all, minus & intersect meant to do?

572






What will be the syntax to find current date and time in format "yyyy-mm-dd"?

577


What is oracle instant client?

581


Calculate difference between 2 date / times in oracle sql?

586


Is oracle the best database?

530


What is Data Dictionary Cache in Oracle?

670


How to use "in out" parameter properly?

628


What is meant by raw datatype?

579


How to convert times to characters in oracle?

619


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1454


Write a syntax for update query in oracle?

628