Re: Dynamic trigger values
Date: Tue, 14 Jan 2003 03:58:13 GMT
Message-ID: <pVLU9.672957$%m4.3384528_at_rwcrnsc52.ops.asp.att.net>
This is going to be real slow if you actually accomplish it. Just write a
script to write a script to generate the triggers for the tables.
Jim
"FedStruggle" <radha_a_at_hotmail.com> wrote in message
news:f757a807.0301131017.3d33b8b8_at_posting.google.com...
> Hello
> I am trying to write a trigger which would get the column names from
> the "user_tab_columns" table and loop through the columns to compare
> the old and new values. The problem is to get these values. How can I
> do :old.column_name where the column name will be stored in a variable
> ?
>
> The idea of doing this trigger is to create a history of changes made
> to a particular record in a table. There are about 100 tables for
> which we need this information. And so we are trying to make the code
> common.
> Thanks a lot.
Received on Tue Jan 14 2003 - 04:58:13 CET