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