Answer / vani

Instead of triggers are the procedures that execute in
place of Data Manipulation language (DML)statement on a
table.

for example, if i have INSTEAD-OF-UPDATE Trigger on
TableA,and i execute an update statement on that table,the
code in the INSTEAD-OF-TRIGGER will be executed instead of
the update statement that I executed.

Answer / s.vanitha

The INSTEAD OF triggers execute instead
of the original data modification. INSTEAD OF trigger are
allowed for both tables and views.

Answer / apparao akki

None of the above answers are correct..

The Main objective of INSTEAD OF TRIGGERS is.. To handling
the complexity of View.,i.e; to manipulating the
non-updateable views(the views that have created by many
tables with help of joins, Group by operators or set operator's)

if u need more .. contact on my mail:

apparao.akki@oracle.com

What are the benefits of filtered indexes?

0 Answers  

---

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

---

what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,

---

How to receive returning result from a query?

0 Answers  

---

What is bcnf normalization form?

0 Answers  

---

Where is trigger in sql server?

0 Answers  

---

What is difference between delete & truncate commands?

0 Answers  

---

What are the different Topologies in which Replication can be configured?

0 Answers  

---

Explain couple pf features of SQL server

2 Answers  

---

what is package and it uses and how can u call a package

0 Answers   Satyam,

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

---

How to concatenate two character strings together?

0 Answers  

---