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 are the differences between blob and clob in oracle?
When do you get a .pll extension in oracle? Explain its importance
What is the meaning of recursive hints in oracle?
What is the scope of a local variable?
what happened to the global index when I truncate the data in one of the partition?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How many file formats are supported to export data?
Please explain compound trigger in oracle?
How to save query output to a local file?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to bring a tablespace online?
Can we commit inside a function in oracle?
What are the limitations oracle database 10g xe?
How to set up autotrace for a user account?
How to turn on or off recycle bin for the session?