Explain materialized views and how they are used.
Answers were Sorted based on User's Feedback
Answer / shams tabrez
Materialized views are dynamic views, means if materialized
were created on 2 tables than if any update happens in
these two tables than it reflect on materialized views
which is created on these 2 tables.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / shyamal mondal
Materialized view is a database object which contains the result of a query. It is the local copy of data located remotely or are used to create summary table based on aggregation of table's data.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is index? How many types of indexes?
what is sql*loader parameters and where we will use it.
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
Give the stages of instance startup to a usable state where normal users may access it.
What is the use of lockboxes? : oracle accounts receivable
How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
What are the mandatory setups in setting up a PO in oracle
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
which one is currently in used software cmpanies.
What is the difference between recovery and restoring of the oracle database?
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....