Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / riddhi
1) view don't store data whereas mview contains copy of data
2) performance of mview is better then view
3)view contains updated data whereas mview not contain up to date Data because there is an activity of data refresh in mview
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the truncate in oracle?
What is Segment Advisor in Oracle?
How to get maxsal , minsal, ename department wise in single query
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Calculate difference between 2 date / times in oracle sql?
What are the original export and import utilities?
How to update values on multiple rows in oracle?
How to create an oracle testing table?
What happens to the indexes if a table is recovered?
What is key preserved table?
What is Library Cache in Oracle?
What is oracle update statement with inner join ?
Describe the types of sub query?
What is raw datatype?
What are the uses of Database Trigger ?
