Narayana Tutorial

Online Java Tutorial Blog

How to Disable and Enable triggers in 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 Trigger in a table

Syntax

ALTER TRIGGER <trigger-name> DISABLE;

Example

ALTER TRIGGER NarayanaTutorialTrigger DISABLE;

 

Disable ALL Triggers in a table

Syntax

ALTER TABLE <table-name> DISABLE ALL TRIGGERS;

Example

ALTER TABLE NarayanaTutorial_TABLE DISABLE ALL TRIGGERS;

DROP Trigger

Syntax

DROP TRIGGER <trigger-name>;

Example

DROP TRIGGER NarayanaTutorial_Trigger;

 

 

Narayanaswamy

Hello! I am Narayanaswamy founder and admin of narayanatutorial.com. I have been working in IT industry more than 7 years. NarayanaTutorial is my web technologies blog. My specialties are Java / J2EE, Spring, Hibernate, Struts, Webservices, PHP, Oracle, MySQL, SQLServer, Web Hosting and Website Development.

I am a self learner and passionate about training and writing. I am always trying my best to share my knowledge through my blog.

Leave a Reply

Narayana Tutorial © 2018 Frontier Theme
Show Button
Hide Button