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 u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

How to rename a table?

0 Answers  

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

What is the difference between the implicit and explicit cursors?

0 Answers  

---

What is assignment operator in pl sql?

0 Answers  

---

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  

---

How do I install sql?

0 Answers  

---

What is synonyms?

0 Answers  

---

define sql insert statement ? : Sql dba

0 Answers  

---

Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,

---

What are the types of sql commands?

0 Answers  

---

What is java sql drivermanager?

0 Answers  

---