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.

BY Best Interview Question ON 19 Feb 2019