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 |
key flexfield structure
What is difference b/w Credit memo and Adjustment in AR.
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
pl help me, i want oracle HRMS training institute address,in chennai
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
8. Supporting AP, AR and GL?
what are the API of GL,PO,AP
Name two files used for network connection to a database.
Compare and contrast TRUNCATE and DELETE for a table.
Give the reasoning behind using an index.
Explain materialized views and how they are used.