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.