Narayana Tutorial

Online Java Tutorial Blog

Tag: Drop Trigger

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