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

Home -> Community -> Usenet -> c.d.o.misc -> Re: help with triggers and mutating tables

Re: help with triggers and mutating tables

From: sybrandb <sybrandb_at_gmail.com>
Date: 15 May 2007 07:45:56 -0700
Message-ID: <1179240356.710785.151310@p77g2000hsh.googlegroups.com>


On May 15, 2:27 pm, "balaji.call..._at_gmail.com" <balaji.call..._at_gmail.com> wrote:
> You can create update triggers for each column separately. This will
> give you more flexibility on debugging the problem. I think the syntax
> is like
>
> create or replace trigger trigger_name after update of column_name on
> table_name ....
>
> Balaji

This is dangerous advice. Triggers are parsed always, and Oracle doesn't guarantee the execution order for different triggers on identical events.

--
Sybrand Bakker
Senior Oracle DBA
Received on Tue May 15 2007 - 09:45:56 CDT

Original text of this message

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