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 -> PL/SQL Procedure

PL/SQL Procedure

From: BobGreat <bobgreat_at_aol.com>
Date: 2 Jul 1998 01:32:53 GMT
Message-ID: <1998070201325300.VAA21879@ladder03.news.aol.com>


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 - 20:32:53 CDT

Original text of this message

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