Oracle Topics

Oracle DISABLE Trigger:-
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".

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:- 
  

ALTER TABLE table_name DISABLE ALL TRIGGERS;


Example:- 
  

ALTER TABLE SUPPLIERS DISABLE ALL TRIGGERS;


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