Disable a trigger : Disable Enable Trigger « Trigger « Oracle PL/SQL Tutorial






You can stop a trigger from firing by disabling it using the ALTER TRIGGER statement.

ALTER TRIGGER before_employee_salary_update DISABLE;
28.8.Disable Enable Trigger
28.8.1.Disable a trigger
28.8.2.Enable a trigger
28.8.3.Enable and disable triggers
28.8.4.Alter trigger to disable it or enable it