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 |
what is the back ground program run while transferring data from OM to AR?
what type of testing u r doing?
Is there any limitations on responsibility assigned to a apps user?
What is an Index , Types od index why we are use index.
where is chandra institute in hyderabad for oracle apps technical training ?
What is invoice?
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
why do we validate the records while developing interface?
oracle apps architecture
How to write the no data found in XML Publiser Report in apps?
How you will Diaplay the Company LOGO In report.Can anyone knows please give solution