Home -> Usenet -> comp.databases.oracle -> Accessing fields in a record by a Number

Accessing fields in a record by a Number

From: Derrick Bradbury <derrickb_at_terraport.net>
Date: 1995/12/27
Message-ID: <4bs1os$jc1_at_archangel.terraport.net>#1/1 






I am currently working on a project that has a log of changes to be
made to a particular table, and all I have is a FIELD NUMBER. I was
wondering if there was a way (in PL/SQL) to access the field by a
number (Sort of like an array).


ie:	update benefits set benefits.field(12) = NewValue where
		key1 = '11' and key2='325345';





If this is possible, it would save me a lot of time!



TIA



Derrick Bradbury
Received on Wed Dec 27 1995 - 00:00:00 CET












Original text of this message