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

Home -> Community -> Mailing Lists -> Oracle-L -> brutally simple question - number of triggers on a table

brutally simple question - number of triggers on a table

From: Paul Drake <bdbafh_at_gmail.com>
Date: Thu, 21 Apr 2005 16:52:21 -0400
Message-ID: <910046b4050421135266c64657@mail.gmail.com> 





Just looking for opinions, unsubstantiated accepted, substantiated -
even better.



Q: How many triggers on a table is too many?



    
  
  1.   any (all the business rules and constraints belong in THE application).
  
  2.   one massive trigger/package for all app owner tables.
  
  3.   two (all that is required is one).
  
  4.   one for each triggering event type.
  
  5.   they're free ... as many as all the developers desire
  
  6.   what's a trigger?
  
  7.   other.






thanks. have fun.



Paul

--
http://www.freelists.org/webpage/oracle-l


Received on Thu Apr 21 2005 - 16:56:33 CDT












Original text of this message













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