Compound Trigger

From Ittichai Chammavanijakul's Wiki
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;