Sometimes you might find that you are required to disable all of the triggers on a table. In PL/SQL you can disable all the triggers on a table using ALTER TRIGGER statement.
PL/SQL Disable all Trigger Syntax
Syntax
Where:
table_name: The table name that all triggers should be disabled on.
PL/SQL Disable all Trigger Example
To show how to disable all the trigger using the DISABLE ALL TRIGGERS statement, use the following syntax: