Re: Newbie needs help with dynamic column name in SQL

Hi!
Maybe something like this would be better ? ;

i:=1;
cmd='update table1 set ';
>WHILE i<=20 LOOP
> fldname:='Field' || TO_CHAR(i);
> cmd:=cmd||' fldname = ''ABC'''
> if i<20 then
> cmd:=cmd||',';
> i:=i+1;
>END LOOP

cmd:=cmd||'WHERE blah blah blah';
EXECUTE IMMEDIATE cmd;

HTH, Regards

   Flatline

> >i:=1;
> >WHILE i<=20 LOOP
> > fldname:='Field' || TO_CHAR(i);
> > UPDATE table1
> > SET fldname = 'ABC' <--- fldname would be field1 to field 20
> > WHERE blah blah blah;
> >
> > i:=i+1;
> >END LOOP
> >
> >Is it possible to do this? How do I change the field name dynamically?
> >
> >Thanks in advance.
> >
> >KC
Received on Sat Nov 16 2002 - 09:08:58 CST