what is instead of trigger in where u will use?
Answer Posted / 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 |
Post New Answer View All Answers
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
List the types of flexfield?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
What does appl_top directory contain?
Can you define an erp system?
What is a value set? List its various types.
What do you understand by a set of books?
can we use look up type instead of a pofile option?or valueset?is it possible how?
Explain what are the tables of auto invoice?
Do you know where we can check the status of po?
q)what are the validations in sql*loader
can we get profile values in report without using user exists is it possible how?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What are file in oracle.
what is the differences between internal requisition and internal sales order?