Interested to Buy Any Domain ? << Click Here >> for more details...
what is instead of trigger in where u will use?
- 2 Answers
- 8234 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Explain oracle apps architecture.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what are version control tools used in oracle apps?
what is the difference between %_all and %_f tables
is it possible to run the interface without using oracle apps?
How to create user and how u attach with responsibility.
where is chandra institute in hyderabad for oracle apps technical training ?
In xml report, how to print the headings in every page?
what is the defference between credit memo and debit memo
Steps for DFF registration
What is function?
API?s FOR CUSTOMER INTERFACE? Tell me some API's?
Oracle Apps Technical 
