Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Variable for column name
You'll need to use dbms_sql to accomplish that.
Hth,
--
Sybrand Bakker, Oracle DBA
<dan_beatty_at_my-deja.com> wrote in message
news:7v58hp$nom$1_at_nnrp1.deja.com...
> I would like to use a variable for a column name in a trigger that I'm
> writing.
>
> For example I have:
>
> SELECT field_name
> INTO v_field_name
> FROM field_table;
>
> What I want to do is use the v_field_name as follows:
>
> UPDATE new_table
> SET v_field_name = :NEW.udf
>
> However, this doesn't work. Any help would be appreciated.
> Thanks,
> Dan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 27 1999 - 00:05:24 CDT