This Oracle tutorial explains how to allow a set off in Oracle with syntax and examples.
Description
You may have found that you have disabled a set off on a desk and you want to allow the set off again. You can do this with the ALTER TRIGGER statement.
Syntax
The syntax for a enabling a Trigger in Oracle/PLSQL is:
ALTER TRIGGER trigger_name ENABLE;Parameters or Arguments
trigger_name The name of the set off that you want to enable.
Note
See also how to allow all triggers on a table. See also how to disable a set off on a desk or disable all triggers on a table.
Example
Let’s look at an example that shows how to allow a set off in Oracle.
For example:
ALTER TRIGGER orders_before_insert ENABLE;This example makes use of the ALTER TRIGGER declaration to enable the trigger called orders_before_insert.