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 Enable all Trigger

Sometimes you might found that you have disabled all trigger on a table and you wish to enable the triggers back again. In Oracle you can enable all the triggers on a table using ALTER TRIGGER statement.

Oracle Enable all Trigger Syntax

Syntax

ALTER TABLE table_name ENABLE ALL TRIGGERS; 

Where:

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

Oracle Enable all Trigger Example

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

ALTER TABLE tblCustomerLoan ENABLE ALL TRIGGERS;