Materialized view is a database object which contains the result of a query

Explain materialized views and how they are used.

Question Posted / shyamal mondal

2 Answers
6231 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by hz_ in customer tables? : oracle accounts receivable

1142

Explain how to close periods in ar. : oracle accounts receivable

1233

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2106

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2276

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2140

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2877

What is chargeback invoice? How do we create it? : oracle accounts receivable

1281

what is difference between inner join & nested query or subqueries

2963

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17492

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2207

Is there any link between pr form(purchse requisition)and po form(purchase order)

2647

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1006

key flexfield structure

2111

Explain about party and customer in ar : oracle accounts receivable

1143

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2160