Re: Accessing fields in a record by a Number

From: Vivekanandhan Raja <vraja_at_us.oracle.com>
Date: 1995/12/29
Message-ID: <4c1os5$nt6_at_inet-nntp-gw-1.us.oracle.com>#1/1


derrickb_at_terraport.net (Derrick Bradbury) wrote:
>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
>
>
I don't think this is possible. However you could just use a PL/SQL block or a stored procedure that would do the trick -- different update statements depending on the field # passed in as an argument. Received on Fri Dec 29 1995 - 00:00:00 CET

Original text of this message