Friday, 8 December 2023

Trigger Preceedes FOLLOWS

 The FOLLOWS clause, allowing you to indicate that a trigger fire after a specified trigger.

Ref. http://www.grassroots-oracle.com/2009/09/precedes-follows-follows.html

create or replace trigger package_trigger
after update of salary
on employees
for each row
begin
dbms_output.put_line('package_trigger');
end old_way;
/

create or replace trigger custom_stuff
after update of salary
on employees
for each row
follows package_trigger
begin
dbms_output.put_line('custom_stuff');
end old_way;
/

No comments:

Post a Comment