Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Better one big trigger or many small?

Re: Better one big trigger or many small?

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Tue, 26 Feb 2002 14:06:27 +0000 (UTC)
Message-ID: <a5g4p3$36l$1@helle.btinternet.com> 





I suggest you make 1 large trigger instead of multiple small ones. The thing
with triggers is that you cannot say which one is going to be fired first.
Secondly when figuring out problems it is more difficult when you have
multiple triggers. Fewer triggers make things easier to bug fix.


--
Gerrit-Jan Linker
Author of SQL*XL: the addin for Excel to access databases
http://www.oraxcel.com


Received on Tue Feb 26 2002 - 08:06:27 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US