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 Virtual Memory?
what is debit memo and credit memo in AR?
Explain the difference between a data block, an extent and a segment.
What is auto invoicing? : oracle accounts receivable
For web applications from which version of Oracle is suitable?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
whats the difference between join command and Cartesian product using example?
what are the API of GL,PO,AP
What is the importance of batch source set up in ar? : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
Explain about party and customer in ar : oracle accounts receivable