Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Problem
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
![]() |
![]() |