Answer / chandan kumar

The above answer is right till here....view is a virtual
table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also
same
like the view but it exist in rdbms.

We use the Materialized View in that Senerio when we have
large amount of database and we need to refresh that in a
time being.

Answer / thanigesan.m

view is a virtual table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also same
like the view but it exist in rdbms.
we use materialized view
e.g if we r having a table with 4 columns
empno ename sal comm
33 xxxy 1000 234
we can create a materialized view as totalsal by sum that 2
columns....

How do I run sql?

0 Answers  

---

how to convert numeric values to character strings? : Sql dba

0 Answers  

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

What is the basic structure of PL/SQL ?

6 Answers  

---

Which sql statement is used to delete data from a database?

0 Answers  

---

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

Explain the the update statement in sql?

0 Answers  

---

how to start mysql server? : Sql dba

0 Answers  

---

What is the difference between sql/pl-sql/embeded sql?

3 Answers  

---

Which is faster truncate or drop?

0 Answers  

---

What are three advantages to using sql?

0 Answers  

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---