Re: Get name of column in a trigger

Within the trigger, you can compare the old and new values:

IF :OLD.column_name = :NEW.column_name

John Alexander
www.SummitSoftwareDesign.com
St. Petersburg, FL

<michael_gressman_at_my-deja.com> wrote in message news:961lrn$l3o$1_at_nnrp1.deja.com...
> Within a trigger, is it possible to get the name of the column where
> data was changed? For example, if a table has columns A, B, C, and D,
> I want to be able to write a trigger that can determine which column A,
> B, C, or D the user changed data in and perform some action specific to
> the column in which the data was changed. I know I can do a row level
> trigger and select which columns will fire the trigger, but my table is
> actually quite a bit larger than 4 columns and I would prefer not to
> have individual update triggers for each column in the table. I am
> also under the assumption that there is a limit to the number of
> triggers that can be placed on one table, so, with a rather large
> table, I won't be able to have a separate trigger for each column.
>
> Thanks,
> Mike
>
>
> Sent via Deja.com
> http://www.deja.com/
>
Received on Sat Feb 10 2001 - 16:18:53 CST