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 !!!

in procedure how to return a value

2 Answers   Wipro,

---

what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  

---

Oder of firing triggers in form

7 Answers   Oracle, Zensar,

---

Tell me some errors names and number what u got while developing the reports?

1 Answers  

---

what are the steps to develop a new report?

7 Answers   Infotech, Satyam,

---

what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,

---

cursor 1 and cursor 2 are there did you open both the cursors at a time or not?

2 Answers   Infosys,

---

wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,

---

in GL module specifing org_id or not?

1 Answers  

---

What is the interface?

3 Answers  

---

how to make a parameter optional in the query?

2 Answers   Wipro,

---

What is oracle soa suite and what are its different components?

0 Answers  

---