Re: Accessing fields in a record by a Number
From: George Xu <George_Xu_at_Nt.Com>
Date: 1995/12/28
Message-ID: <4bva4l$irn_at_nbdchc4.bnr.ca>#1/1
Date: 1995/12/28
Message-ID: <4bva4l$irn_at_nbdchc4.bnr.ca>#1/1
Hi,
PL/SQL is not designed to the process you require, however, you can put that field number as a column in the table, and update the record as following:
update benefits set benefits.field = NewValue where
key1 = '11' and key2 = '325345'
and RecordNumber = 12
Good luck
George Xu
IS, Northen Telecom Ltd.
Received on Thu Dec 28 1995 - 00:00:00 CET