PL/SQL Exception

PL/SQL Exception

PL/SQL Interview Questions

PL/SQL Interview Questions and Answers

PL/SQL Disable all Trigger

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



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: