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 -> Re: PL/SQL Problem

Re: PL/SQL Problem

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 19 Jan 2005 14:56:46 -0800
Message-ID: <41eee5a2$1_2@127.0.0.1>


pasindud_at_gmail.com wrote:

> Hi,
>
> I have a record type and I also have a string variable and a interger
> value.
> ex:
> rec MY_TAB%ROWTYPE;
> column_name VARCHAR2(30);
> column_index INTEGER;
>
> Is there a way to access get a value from the rec given when i have a
> value for column_name or column_index.
>
> Yes I know i can get the value like rec.my_field. But is there a way to
> get this when the fild_name is given dynamically through another
> variable like column_name or when the column_id is given through
> column_index.
>
>
> PS:I'm Using Oracle9i

AFAIK No.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Jan 19 2005 - 16:56:46 CST

Original text of this message

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