Using Disable all Triggers on a table in Oracle

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

Description

Once you have created Triggers in Oracle, you may discover that you are required to disable all of the triggers on a table.. You can do this with the ALTER TRIGGER statement.

Syntax

The syntax for a disabling all Triggers on a desk in Oracle/PLSQL is:

ALTER TABLE table_name DISABLE ALL TRIGGERS;

Parameters or Arguments

table_name The identify of the table that all triggers have to be disabled on.

Note

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

Example

Let’s appear at an instance that suggests how to disable all triggers on a desk in Oracle.

For example:

ALTER TABLE orders DISABLE ALL TRIGGERS;

This instance makes use of the ALTER TRIGGER announcement to disable all triggers on the desk known as orders.