1.

Please explain compound trigger in Oracle?

Answer»

The compound trigger was in introduced in Oracle 11g. This single trigger on a table enables the user to specify the actions for each of the four timing points:

  • Before the firing STATEMENT
  • Before each row that the firing statement affects
  • After each row that the firing statement changes
  • After the firing statement

In other words, Compound trigger MERGES all the four triggering EVENTS into the single piece of CODE, and as a result, the performance of the DATABASE server is improved during the bulk operations. The Compound trigger is only for the DML triggers.


Discussion

No Comment Found

Related InterviewSolutions