Javatpoint Logo
Javatpoint Logo

Oracle ENABLE Trigger

The ALTER TRIGGER statement is used to enable a trigger.

Syntax

Parameters

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

Oracle ENABLE Trigger Example

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

Oracle Enable trigger

Oracle ENABLE ALL Triggers Example

Syntax

Example

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

Oracle Enable trigger 2



Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA