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
What is memory advisor in Oracle?
How to concatenate two text values in oracle?
How to experiment a data lock in oracle?
Write a syntax for update query in oracle?
 How to use an oracle sequence generator in a mapping?
Is there a function to split a string in plsql?
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.
What is a read write transaction in oracle?
How to drop a tablespace?
How to convert a string to a date in oracle database?
Explain database link?
How to best split csv strings in oracle 9i?
What is oracle latest version?
What are the different types of failures that occur in Oracle database?
How to test null values?
