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 anonymous block in sql?

1174

---

What is schema in sql example?

1282

---

Can you join a table to itself?

1225

---

How would you reference column values before and after you have inserted and deleted triggers?

1117

---

Explain the difference between triggers and constraints?

1025

---

Is full outer join same as cross join?

1018

---

What is union and union all keyword in sql?

1112

---

What is the difference between left and left outer join?

994

---

What is a call statement? Explain with an example.

1071

---

What are the three forms of normalization?

1093

---

How do I create a sql script?

1143

---

What is time based sql injection?

1036

---

What is a sql statement?

1019

---

Why having clause is used in sql?

1021

---

What is sqlexception in java?

1038

---