Interested to Buy Any Domain ? << Click Here >> for more details...
what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
snapshots?
- 2 Answers
- 14423 Views
- I also Faced
- E-Mail Answers
Answer Posted / its me...
A materialized view is a database object that contains the
results of a query. The FROM clause of the query can name
tables, views, and other materialized views. Collectively
these objects are called master tables .
materialized views allow you to maintain copies of remote
data on your local node.
You can select data from a materialized view as you would
from a table or view.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is SQL Tuning Advisor in Oracle?
How view is different from a table?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is max rowid in oracle?
What are dml statements in oracle?
What privilege is needed for a user to connect to oracle server?
What is the data type of dual table?
What is oracle update statement with inner join ?
What is sharded cluster?
What are the uses of synonyms?
How to write date and time literals in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the data types in oracle?
How to create a temporary table in oracle?
How to create tables for odbc connection testing?
