Narayana Tutorial

Online Java Tutorial Blog

Tag: Triggers

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 […]

Narayana Tutorial © 2018 Frontier Theme
Show Button
Hide Button