Answer Posted / dinesh

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table.

CREATE MATERIALIZED VIEW view-name
BUILD [IMMEDIATE | DEFERRED]
REFRESH [FAST | COMPLETE | FORCE ]
ON [COMMIT | DEMAND ]
[[ENABLE | DISABLE] QUERY REWRITE]
[ON PREBUILT TABLE]
AS
SELECT ...;

What is the use of pl/sql table?

1048

---

How many sql commands are there?

1102

---

what is 'mysqlimport'? : Sql dba

1019

---

What is the life of an sql statement?

1000

---

Is ms sql is free?

1008

---

What is the difference between view and stored procedure?

951

---

What are the three forms of normalization?

1033

---

What is a subquery in sql?

1023

---

What is the current version of sql?

1005

---

what are string data types? : Sql dba

1025

---

Can we commit inside a trigger?

980

---

How many commands are there in sql?

1010

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1110

---

What is microsoft t sql?

927

---

What are pl/sql cursors?

1037

---