Replacing Triggers

The status of a trigger is the only portion that can be altered. To alter a trigger’s body, the trigger must be re-created or replaced. When replacing a trigger, use the create or replace trigger command (refer to “Trigger Syntax” and the examples earlier in the chapter).