This Oracle tutorial explains how to disable a trigger in Oracle with syntax and examples.
Once you have created a Trigger in Oracle, you might find that you are required to disable the trigger. You can do this with the ALTER TRIGGER statement.
The syntax for a disabling a Trigger in Oracle/PLSQL is:
ALTER TRIGGER trigger_name DISABLE;
Parameters or Arguments
The name of the trigger that you wish to disable.
- See also how to disable all triggers on a table.
- See also how to enable a trigger on a table or enable all triggers on a table.
Let's look at an example that shows how to disable a trigger in Oracle.
ALTER TRIGGER orders_before_insert DISABLE;
This example uses the ALTER TRIGGER statement to disable the trigger called orders_before_insert.