Oracle Tips by Burleson Consulting. Question: I don't understand the name instead of triggers, and I want to understand that an instead-of trigger does and why we use an instead-of trigger.Answer: The name instead-of trigger is indeed confusing. The name instead of comes from the trigger syntax where you can specify instead of for a trigger:CREATE OR REPLACE TRIGGER. MY_INSERT_TRIG. INSTEAD OF INSERT. AS. DECLARE (Update some stuff instead of inserting) . . . . You can also see instead of update and instead of delete inside instead-of trigger syntax.In a nutshell, when placed inside an insert trigger, the instead of insert syntax negates the insert and perform other processing instead.he name instead of comes from the trigger syntax where you can specify instead of for a trigger: CREATE OR REPLACE TRIGGER. MY_INSERT_TRIG. INSTEAD OF INSERT. AS. DECLARE (Update some stuff instead of inserting) . . . . You can also see instead of update and instead of delete inside instead-of trigger syntax.