Answer / nivedita

view is a virtual table.view does not contain any data
while material view has its own data.material views are the
local copies of remote data.

Answer / yaswanth

A view will takes the output of the query. But a materialized
view stores the output of the query which is not possible in
view

Answer / suresh babu

View:view is a logical table,it don't have own data,the
query which we mentioned after the create view statement
will be compiled and stored in server as a database
object.once we call the view,the compiled query will be
fetch the data from master table.
The DML operations will be reflected in master table or
view suddenly.
Materialized view:The Materialized view required physical
memory space.it will be created from target master
table,which located in some other location.A materialized
view can be created either single mater table or multimater
tables from multiple master sites.the changes which we have
done in master table will reflect in particular interval
time.the materialized view,which created from multiple
master tables,will updated its individual batch files....

Answer / papia

view does not contain actual data but MV contains data.MV
needs to be refereshed after a particular interval.Bit when
a view is queried it actually queries the underlying tables.

Which one is better sql or oracle?

0 Answers  

---

How do you copy a table in sql?

0 Answers  

---

What are records give examples?

0 Answers  

---

what does myisamchk do? : Sql dba

0 Answers  

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

Why are aggregate functions called so?

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

Give the order of sql select?

0 Answers  

---

What is a recursive stored procedure?

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---

What is function and procedure in pl sql?

0 Answers  

---