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 |
Is soa a part of oracle fusion middleware?
testing tools?
0 Answers BirlaSoft, Convergys,
what is the defference between credit memo and debit memo
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
In support project one ticket alloted which steps follows manualy tell me ?
about TCA architecture
what is user exit and wat program do we write in user exit?
what is fiscalcalendar?
What is the Lookup's and what is the use of lookup's?
Do you know what are user profiles in apps. Any examples you can give?
What is instead of trigger in where we will use?
How to move the one file from one instance to another instance? And your scripts also?