Answer / rajesh venati

View are classified in to two types.
1. Simple View
2. Complex View

==>DML Operations are not possible in complex views, because,
if u create a view more than one table or
if u create a view using group function or
if u create a view using distinct keyword etc.,
those are called complex view.

If u want perform DML Operations on Complex Views, then we
will go for Instead of Trigger.

Through the Instead of Triggers we can perform DML
Operations on a Complex View.

Answer / bmk

Both are database objects and it behaves diff.View doesn't
contain data and tied with sql.Trigger is an event,trigger
will create on table with after/before with DML operations.

Answer / vivekanandhan

view is used to minimize the complex query of table(s), thru view we can do insert,update,delete where as trigger is an event which will execute automatically when any DML operations provided against the table.

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,

---

What is the purpose of design view?

0 Answers  

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

What is an exception in pl/sql?

0 Answers  

---

Can we join same table in sql?

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

How do I find duplicates in the same column?

0 Answers  

---

How do I view output in sql developer?

0 Answers  

---

How to remove duplicate rows from a table?.

3 Answers  

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

---

What is the current version of postgresql?

0 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---