Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: pl/sql dynamic sql

Re: pl/sql dynamic sql

From: R Chin <rchin_at_panix.com>
Date: Tue, 18 Jun 2002 12:11:19 -0400
Message-ID: <aenlr4$hpf$2@reader1.panix.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US