Using Enable all Triggers on a table in Oracle

This Oracle tutorial explains how to allow all triggers on a desk in Oracle with syntax and examples.

Description

You might also have determined that you have disabled all triggers on a table and you wish to enable the triggers again. You can do this with the ALTER TABLE statement.

Syntax

The syntax to enable all triggers on a desk in Oracle/PLSQL is:

ALTER TABLE table_name ENABLE ALL TRIGGERS;

Parameters or Arguments

table_name The identify of the table that all triggers must be enabled on.

Note

See additionally how to enable a trigger. See additionally how to disable a set off on a desk or disable all triggers on a table.

Example

Let’s seem at an example that shows how to enable all triggers on a table in Oracle.

For example:

ALTER TABLE orders ENABLE ALL TRIGGERS;

This instance uses the ALTER TABLE assertion to allow all triggers on the desk known as orders.