Interested to Buy Any Domain ? << Click Here >> for more details...
what is instead of trigger in where u will use?
- 2 Answers
- 8202 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 |
HOW U DISPLAY THE FLEXFIELD DATA IN APPS?
How to attach the multiple templates in XML Pub Report?
If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?
how to call report from oracle oracle apps11i?
tell me the scenarios of between pages in reports
explain p2p cycle? what are the tables used for this?
what is meant by Drill Down in Discoverer report? why it will be use?
what is the difference between varchar and varchar(2)?
What are Mandatory triggers to write in the block, which is created on view?
How can u populate data into po_headers_all segment2 column?
where we can check the status of po.
what is flexfield qualifier?
Oracle Apps Technical 
