Blog Detail

Enable and Disable Triggers in Oracle

25 Jan 11
admin
No Comments
Hi,

It has been possible to enable and disable triggers for some time using the ALTER TRIGGER and ALTER TABLE commands.

Syntax:-

ALTER TRIGGER DISABLE;
ALTER TRIGGER ENABLE;
ALTER TABLE DISABLE ALL TRIGGERS;
ALTER TABLE ENABLE ALL TRIGGERS;

Happy Programing…

Leave A Comment