This Oracle tutorial explains how to disable a trigger in Oracle with syntax and examples.
Description
Once you have created a Trigger in Oracle, you may find that you are required to disable the trigger. You can do this with the ALTER TRIGGER statement.
Syntax
The syntax for a disabling a Trigger in Oracle/PLSQL is:
ALTER TRIGGER trigger_name DISABLE;Parameters or Arguments
trigger_name The title of the set off that you want to disable.
Note
See additionally how to disable all triggers on a table. See also how to allow a set off on a desk or allow all triggers on a table.
Example
Let’s look at an instance that suggests how to disable a trigger in Oracle.
For example:
ALTER TRIGGER orders_before_insert DISABLE;This example makes use of the ALTER TRIGGER statement to disable the trigger known as orders_before_insert.