Answer / narenkumar reddy

Mv is database object it contain the data stored physically
from select stmt of query
first time it will get the data base table next time onwards
based on refresh methods mv are created tables and views and
also mv
there three types of refresh methods
1.complete(the whole query execute)
2.fast(only modified records are updated target table i.e
incremental loading)
3.force(some times means when we r using agg function on
that time fast option is not working so we go for force option)

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

Can we edit a view in sql?

0 Answers  

---

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

Which is the correct statement about truncate and delete?

0 Answers  

---

How to select unique records from a table?

0 Answers  

---

What are the two types of cursors in pl sql?

0 Answers  

---

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

---

Explain the purpose of %type and %rowtype data types?

0 Answers  

---

What is difference between sql and excel?

0 Answers  

---

Can we insert in sql function?

0 Answers  

---

Which is faster view or stored procedure?

0 Answers  

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

---