Database Trigger execution order
Code:create table test_11(A NUMBER, B NUMBER); create or replace TRIGGER tr_before_tab_inst before insert on test_11 begin dbms_output.put_line('Before insert on table'); end; create or replace TRIGGER tr_after_tab_inst after insert on test_11 begin dbms_output.put_line('After insert on table'); end; create or replace TRIGGER tr_before_row_inst before insert on test_11 for each row begin dbms_output.put_line('before insert on row'); end; create or replace TRIGGER tr_after_row_inst after insert on test_11 for each row begin dbms_output.put_line('after insert on row'); end; SQL> insert into test_11 values(1,1); Before insert on table before insert on row after insert on row After insert on table 1 row created.





Reply With Quote