Term: TRIGGER. Definition: An Oracle trigger is a database object that is attached to a table. It is similar in many ways to a stored procedure, except that a trigger is run or fired in response to an INSERT, UPDATE or DELETE action. You decide what actions or events are to take place when the trigger is fired by placing code in the trigger.