Skip to Main Content

Oracle Database Discussions

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!

Are triggers evil?

731589Nov 8 2009 — edited Nov 9 2009
Hi,

A friend who works directly with Oracle told me everything must be done in order to try to avoid using triggers, but I couldn't understand why.

I'm not an Oracle (or any other database) expert, but I can understand that a trigger is a block of code that is executed for every insert, update or delete (I know you can say when to run it when you create it), so you have to be cautious not to run things too complicated or to "heavy" in order to not make the whole database slow. But, again, I think you need to be cautious with what your triggers are doing, but you don't need to avoid using them.

Is there anything I am missing?

Thanks in advance,

João Toledo
This post has been answered by Hoek on Nov 8 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2009
Added on Nov 8 2009
5 comments
1,095 views