Re: 2 triggers or 1??

On Wed, 17 Mar 2004 00:58:51 GMT, AK <ak_at_ak.org> 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

The general guidance is that the order of trigger execution is not guaranteed. Need I say more?

--
Sybrand Bakker, Senior Oracle DBA