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 |
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
what is correlated subquery
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
What background process refreshes materialized views?
What are the mandatory setups in setting up a PO in oracle
WHAT IS CARTESIAN PRODUCT?
Difference between negative and positive adjustments : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
how to replace not in with not exist?
You have just compiled a PL/SQL package but got errors, how would you view the errors?