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 difference between BPA AND Contract.
Can you define an erp system?
Cycle of requestion to receving transaction.
How to link between inventory and OrderManagement.
what is meant by lexical parameter
is it possible to run the interface without using oracle apps?
in one report using two layout models.if yes how to do
What is multoorg and what is it's level or structure
Define multi org structure with example(take any businees).
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
what is the need of registering table in apps?
What is OM Cycle and What do u mean by Alternate Item