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!

Want to drop trigger after checking the existence of it in the database.

605332Nov 19 2008 — edited Nov 19 2008

Hi All,
I am using oracle 10g.I have an trigger 'x' on table 'x_tab'.After dropping the trigger,If I will try to drop
again,it will show an error message that "trigger does not exist".I want a sql where it will search for
the existence of trigger in the databse,and the sql statement will return without any error.
At least it should not give error mentioned above.

Please help if anybody have any idea.

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2008

Added on Nov 19 2008

12 comments

4,288 views