Re: pl/sql dynamic sql

tony wrote:
>
> I want to do something like this in pl/sql...
>
> INSERT into '||v_tblnm||'
> ('||v_code||', '||v_desc||')
> VALUES(UPPER('||newcode||'),'||newdesc;
>
> Is it possible?

Yes, but look at your syntax (right ) missing).

Regards,

Knut Received on Wed Jun 19 2002 - 06:42:16 CDT