Javatpoint Logo
Javatpoint Logo

Oracle DISABLE Trigger

The ALTER TRIGGER statement is used to disable a trigger.

Syntax

Parameters

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

Oracle DISABLE Trigger Example

This example will disable the trigger called "SUPPLIERS_T2" from the table "SUPPLIERS".

Oracle DISABLE ALL Triggers Example

If there is more than one trigger in a table and you want to disable all the triggers from the database then you can do it by ALTER TABLE statement.

Syntax

Example

This example will disable all triggers from the table "suppliers".

Oracle Disable trigger




Youtube For Videos Join Our Youtube Channel: Join Now

Feedback


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA