I was reviewing some features in Oracle and, basically, every single time I review them I find something new. Seems Oracle Databases’ features are near to infinite and we frequently find some that can really add value to our solutions.
So here is something you may not be aware and is really cool:
Oracle allows more than one trigger to be created for the same timing point, but up to version 11g is not possible to establish the execution order of execution. The Oracle 11g trigger syntax now includes the FOLLOWS clause to guarantee execution order for triggers defined with the same timing point.
The example below establish that second_trigger is executed after first_trigger before inserting each row in table_example.
CREATE OR REPLACE TRIGGER second_trigger BEFORE INSERT ON table_example FOR EACH ROW FOLLOWS first_trigger BEGIN NULL; END; /