Day: June 22, 2018

How to Disable and Enable triggers in oracle

oracle

In this post, we are discussing on how to enable, disable and drop triggers in oracle.   Enable ONE Trigger in a table Syntax ALTER TRIGGER <trigger-name> ENABLE; Example ALTER TRIGGER NarayanaTutorial_Trigger ENABLE;   Enable ALL Triggers in a table Syntax ALTER TABLE <table-name> ENABLE ALL TRIGGERS; Example ALTER TABLE NarayanaTutorial_TABLE ENABLE ALL TRIGGERS;     Disable […]