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 location of pre_defined_functions.

1134

---

What is the meaning of disabling a trigger?

1132

---

When you have to use a default "rollback to" savepoint of plvlog?

1140

---

Is coalesce faster than isnull?

923

---

Is sql workbench free?

949

---

How do you declare a constant?

924

---

What is scope and visibility in PL/SQL?

1146

---

What is trigger in sql? Explain

956

---

What are the subsets of sql?

1075

---

How can we link a sql database to an existing android app?

1002

---

What packages are available to pl/sql developers?

1012

---

Do ddl statements need commit?

939

---

how many tables will create when we create table, what are they? : Sql dba

1036

---

Is sql a backend language?

1063

---

What is not equal in sql?

1050

---