Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help with triggers and mutating tables
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 DBAReceived on Tue May 15 2007 - 09:45:56 CDT
![]() |
![]() |