PL/SQL

I am working with Oracle7 Workgroup Server on NT4. I an creating a trigger which will compare new value with old value for each field in the table and then record them in the log table if they differ. The syntax for new & old values is - :new.Employer_Name and old:Employer_Name where Employer_Name is name of the field.

How I could compare values for each field without hardcoding field name (let's say loading all fields names in the array & then scan through this array) ?

For example:

var1 := 'Employer_Name';
and then use var1 in :old and :new constructions . How ?

Thanks in advance.
E-Mail me to bobgreat_at_aol.com
Boris Milrud. Received on Wed Jul 01 1998 - 15:31:20 CDT