What is a materialised view?

Answer Posted / deva

Its the data of the remote database. When we queried for
the data at the remote database/schema, the data/resuls set
is known as the materialized view.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete a column in an existing table in oracle?

605


What is the best way to do multi-row insert in oracle?

567


How to invoke the original export import utilities?

508


Can a formula column referred to columns in higher group ?

2089


How to select some rows from a table in oracle?

598






How do I reset a sequence in oracle?

600


How to Truncate Table in Oracle

659


Does facebook use oracle?

581


How to revoke create session privilege from a user in oracle?

559


What is a partition in oracle?

547


How do I start tns listener?

542


What is the difference between 10g OEM and 11g OEM?

565


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1927


What is a trace file and how is it created in oracle?

554


What are the differences between char and nchar in oracle?

603