Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2 triggers or 1??
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