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.

what is column? : Sql dba

0 Answers  

---

how to shut down the server with 'mysqladmin'? : Sql dba

0 Answers  

---

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

---

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

---

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

---

What is field delimiter?

0 Answers  

---

Can dml statements be used in pl/sql?

0 Answers  

---

What are the parts of a sql statement?

0 Answers  

---

Explain exception handling in pl/sql?

0 Answers  

---