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: <balaji.calluru_at_gmail.com>
Date: 15 May 2007 05:27:50 -0700
Message-ID: <1179232070.440972.321710@l77g2000hsb.googlegroups.com>


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 Received on Tue May 15 2007 - 07:27:50 CDT

Original text of this message

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