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
Why do you create or replace procedures rather that drop and recreate.
What is the difference between Delete, Truncate and Drop in Oracle?
How to delete an existing row from a table in oracle?
What is key preserved table?
What is transaction control statement and how many types of transaction control statement in Oracle?
What to do if the startbd.bat failed to start the xe instance?
How does the on-delete-cascade statement work?
Is the After report trigger fired if the report execution fails ?
How to create a new table by selecting rows from another table?
What is analyze command used for?
How to resolve the ORA-39133 error in Oracle?
Explain what are the type of synonyms?
Explain the blob datatype?
How many data types are supported?
What is an oracle data file?
