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
- 14441 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 the fastest query method to fetch data from the table?
What is an oracle function?
what is the difference between functional dependecy and multilevel dependency?
What is oracle analytical function?
How to convert dates to characters in oracle?
What does sharding mean?
How to call a sub procedure?
What is a partition in oracle?
What is Undo Management Advisor in Oracle?
What to do if the startbd.bat failed to start the xe instance?
Explain overloading. Can functions be overloaded?
How to start your 10g xe server from command line?
Is there a function to split a string in plsql?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to view all columns in an existing table?
