Answer Posted / rashid ansari
materialized view is database object.it just like nomal
view but u can maniputale into mateialized view.when u
fatch data from remotly,materialized view provide fater
fatching data from remote database.when user manipulate on
actual table then simply refersh to materlized view
automatically update materlized view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to export your own schema?
How to return top 5 rows in oracle?
What is a subquery in oracle?
How to invoke the data pump import utility?
Why do we use bulk collect in oracle?
What is private procedure oracle?
State all possible different index configurations a table can possibly have?
How do we get field details of a table?
What are joins, explain all types of joins?
Can we connect to ORACLE db using Windows Authentication?
What is literal?
How to create a new table in oracle?
What is a server parameter file in oracle?
What are the system predefined user roles?
How many types of segments in Oracle?