trig_table_ii : instead of insert -> The triggers that fire instead of performing the execution of DML statements (Insert, Update, and delete) are instead of triggers. In your case, DML will be insert. trig_table_ti : for insert The triggers that fire after performing the execution of DML statements (Insert, Update, and delete) are After/For triggers. In your case, DML will be insert.

Question. Which trigger will fire first or trigger first? Answer. Instead of triggers are fired even before the updates (insert operation) are made in the underlying base tables. So, Definitely, Instead of trigger will fire first. But, here is an important catch. Instead of trigger will execute statements which is inside the create trigger block even if there is some issues with the original insert statement. On the other hand, After/For Trigger will not fire because it will stop if original insert does not work properly.