Two Trigger of same type on same table which will get executed first?

Question

I have a very basic doubt. Suppose we heve two after insert trigger TR1 and TR2 on table 1. One trigger updates same Table 1 and second trigger Call procedure .. I need TR1 to execute before TR2.. How this can be achieved.. Thanks

Answer 1

In Oracle 11G you can use the PRECEDES or FOLLOWS clauses e.g.

create trigger TR2
after insert on table1
for each row
follows TR1 -------------------------------------------------<<
begin
 ...
end;

Prior to 11G the order if firing was indeterminate; the only way to ensure correct execution was to combine the 2 triggers into 1.