7.1. Sequence of Events
You can do the following with an INSERT STATEMENT trigger:
You can perform an aggregate computation on the table. This can be computed before or after the insert.
You can use a statement level trigger to process data that is collected by a row trigger. This is covered in Section 7.4, “Processing Row Captured Data.”
You can signal an event. This can simply be a print statement. It can also be an email or signal to another process using the DBMS_ALERT package.
Figure 7-1 illustrates the behavior of statement level triggers that can perform “Take Action” functions of “Reject the Transaction” functions. The statement level trigger has no knowledge of the before and after values of any changed row. For a comparison with row triggers, ...
Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
