Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


Oracle Disable all Trigger

Sometimes you might find that you are required to disable all of the triggers on a table. In Oracle you can disable all the triggers on a table using ALTER TRIGGER statement.

Oracle Disable all Trigger Syntax

Syntax

ALTER TABLE table_name DISABLE ALL TRIGGERS; 

Where:

table_name: The table name that all triggers should be disabled on.

Oracle Disable all Trigger Example

To show how to disable all the trigger using the DISABLE ALL TRIGGERS statement, use the following syntax:

ALTER TABLE tblCustomerLoan DISABLE ALL TRIGGERS;