Using Enable a Trigger in Oracle

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.