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 number line correlation administrators will use while working with a subquery?

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

What are the different subsets of sql?

0 Answers  

---

How do you delete a trigger?

0 Answers  

---

What is model database? : SQL Server Architecture

0 Answers  

---

What is meant by referential integrity?

0 Answers   Blue Star,

---

How to list all user names in a database?

0 Answers  

---

What is check constraint in sql server?

0 Answers  

---

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

how many type of subquery?

2 Answers  

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,

---