Compound Trigger
Jump to navigation
Jump to search
What is Compound Trigger?
- A compound trigger is actually four different triggers defined as one.
- For example, an UPDATE compound trigger has a before statement, before row, after statement, and after row all rolled into one compound trigger. This a single piece of code, so you can pass variables just like any other monolithic PL/SQL code.
Sample
create or replace trigger tr_compound for update of booking_dton on tab compound trigger : before statement is begin : end before statement; before each row is begin : end before each row; after each row is begin : end after each row; after statement is begin : end after statement; end tr_compound;