brutally simple question - number of triggers on a table
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Apr 2005 16:52:21 -0400
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.
2. two (all that is required is one).
3. one for each triggering event type.
4. they're free ... as many as all the developers desire
5. what's a trigger?
6. other.
thanks. have fun.
Paul
--
//www.freelists.org/webpage/oracle-l
Other related posts:
