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 ...;

List the different type of joins?

1004

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3010

---

How exception handling is done in advance pl/sql?

920

---

What is the command used to fetch the first 5 characters of a string?

1152

---

What is pl sql variable?

938

---

what is denormalization. : Sql dba

1045

---

What are sql indexes?

938

---

explain what is mysql? : Sql dba

1032

---

How do you write a subquery?

968

---

How global cursor can be declare with dynamic trigger ?

2148

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

918

---

How do I know if I have sql express or standard?

979

---

What is sap sql anywhere?

975

---

How to use transactions efficiently : transact sql

993

---

What is equi join in sql?

1010

---