Trigger updating same row

A compound trigger defined on a table has one or more of the timing-point sections described in Table 9-1.

If a triggering statement omits a column list, the trigger fires when any column of the associated table is updated.If a timing-point section is absent, nothing happens at its timing point.A timing-point section cannot be enclosed in a PL/SQL block.Because the trigger uses the clause, it might be executed multiple times, such as when updating or deleting multiple rows.You might omit this clause if you just want to record the fact that the operation occurred, but not examine the data for each row.

Leave a Reply