What is Oracle Enable Trigger ?

• To enable or disable an individual trigger using the ALTER TRIGGER statement.
• The ALTER TRIGGER statement is used to enable a trigger.

Syntax

ALTER TRIGGER trigger_name ENABLE;   

click below button to copy the code. By - oracle tutorial - team

Copy Code

Parameters

• trigger_name: It specifies the name of the trigger that you want to enable.

Oracle ENABLE Trigger Example

ALTER TRIGGER SUPPLIERS_T1 ENABLE;   

click below button to copy the code. By - oracle tutorial - team

Copy Code

• This example will enable the trigger named "SUPPLIERS_T1" in the "SUPPLIERS" table.

Oracle ENABLE ALL Triggers Example

Syntax

ALTER TABLE table_name ENABLE ALL TRIGGERS;  

click below button to copy the code. By - oracle tutorial - team

Copy Code

Example

ALTER TABLE SUPPLIERS ENABLE ALL TRIGGERS;  

click below button to copy the code. By - oracle tutorial - team

Copy Code

• This example will enable all the triggers on the table name "SUPPLIERS".

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning