Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enable/Disable trigger only if the trigger exists

690485Jul 26 2010 — edited Aug 2 2010
Hi all,

This is may be a simple question.

I just want to write a SQL statement to enable/disable trigger only if that trigger exists....

I can disable it by running the below statement

ALTER TRIGGER MY_TRIGGER DISABLE;

But, if I run this statement where the trigger is not defined, throws an error.
Please advise me to disable or enable trigger based on its existance.
This post has been answered by Saubhik on Jul 26 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2010
Added on Jul 26 2010
#pl, #sql
10 comments
6,224 views