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: 2 triggers or 1??

Re: 2 triggers or 1??

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 16 Mar 2004 21:59:32 -0800
Message-ID: <1079503147.529330@yasure>


AK wrote:

> Hi,
>
> I need to write up a PLSQL trigger which does similar work to an
> existing trigger. The existing trigger runs upon insert/update on the
> same table as the new trigger will.
>
> I could write a second trigger for insert/update on table XXX or I could
> take the existing trigger and modify it to include code for the new
> functionality requirement.
>
> What kind of performance impact will there be if one has multiple
> triggers running on the same table? I know it depends on how you code
> but I am hoping to get some general guidance on this please.
>
> thanks,
> -A

One trigger.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Mar 16 2004 - 23:59:32 CST

Original text of this message

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