Answer / sidharth

The primary advantage of INSTEAD OF triggers is that they
allow views that would not be updatable support updates. A
view comprising multiple base tables must use an INSTEAD OF
trigger to support inserts, updates and deletes that
reference data in the tables. Another advantage of INSTEAD
OF triggers is that they allow you to code logic that can
reject parts of a batch while allowing other parts of a
batch succeed.

Answer / krishh

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.

Hope u get it.....
Cheers !!!

how many groups we can create for query?

3 Answers  

---

what is meant by boilerplates?

1 Answers  

---

How can a process be deployed in soa?

0 Answers  

---

Explain oracle apps architecture.

0 Answers  

---

What is the difference between BPA AND Contract.

1 Answers   Accenture,

---

what is instead of trigger. what is the use of that?

3 Answers  

---

what are the sql attributes?

2 Answers  

---

what are the error tables in AP?

6 Answers  

---

what is the difference between procedure and function

4 Answers  

---

Presently u are working in which version?

4 Answers   Accenture,

---

what is the use of format trigger?a

3 Answers  

---

What is cursor?

3 Answers  

---