Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: pl/sql dynamic sql
Sure, seems you already knew the answer (the subject) to your own
question...
Look up "PL/SQL Application Developer’s Guide"...
The details are there.
rc
tony wrote in message <3d0f51e2.615379467_at_news.dal.ca>...
>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?
>
>
>cheers,
>tony
>902.494.1021 w
>902.461.4550 h
Received on Tue Jun 18 2002 - 11:11:19 CDT