Answer / swapna

We can use 'instead of triggers' for views.Using these
instead of triggers we can perform DML operations on a
complex view.In complex views we can not perform DML
operations.But using instead of triggers we can insert ,
delete,update from complex views.

Answer / kmbkrishnan

Instead of Trigger is also like the FOR trigger, which
are triggered at that time of Insert or update or delete.
The FOR trigger will be triggering After the
Insert / Update / Delete (DML) opreation is executed. But
the Instead of Trigger will be triggering while the DML
operation held and the DML operation is discarded.

Answer / suresh kumar somayajula

These Triggers are used to modify the VIEW whaich can't be
modified by DML statements.

Thank you,
Suresh.

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

What does cursor do in sql?

0 Answers  

---

Can procedure in a package be overloaded?

1 Answers   HCL,

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

---

Can a primary key be a foreign key?

0 Answers  

---

wtite down triggr not any entry on Sunday

2 Answers   NIT,

---

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

---

Differentiate between % rowtype and type record.

0 Answers  

---

How do I make sql search faster?

0 Answers  

---

Is primary key an index?

0 Answers  

---

Can we update views in sql?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---