totn Oracle / PLSQL

Oracle / PLSQL: Enable a Trigger

This Oracle tutorial explains how to enable a trigger in Oracle with syntax and examples.

Description

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.

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 trigger that you wish to enable.

Note

Example

Let's look at an example that shows how to enable a trigger in Oracle.

For example:

ALTER TRIGGER orders_before_insert ENABLE;

This example uses the ALTER TRIGGER statement to enable the trigger called orders_before_insert.