The ALTER TRIGGER statement is used to disable a trigger.

Syntax

ALTER TRIGGER trigger_name DISABLE;   

Parameters

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

Oracle DISABLE Trigger Example

ALTER TRIGGER SUPPLIERS_T2 DISABLE;   

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