what is instead of trigger in where u will use?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 6 Yes | 0 No |
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 !!!
Is This Answer Correct ? | 5 Yes | 7 No |
Give a brief overview on OrderManagement.
How many schemas we have? how many you have used?
how do you describe O2C along with tables
how many sections are there in report?
what is back order in OM
How to know the number of invoices generated for one PO from front end (navigation)?
I want to print output in portrait style?where i have to change the settings?
why r u move in the cus_top only why not move another top
why do we go for oracle apps technical other than sap and other packages?
What are the files you have used in the part of Conversion and Interfaces?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What is MO operating units. Why it need to to set this and where .