Re: pl/sql dynamic sql

tony schrieb:
> 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?

It depends on your version of Oracle you are running.

Look for EXECUTE_IMMEDIATE if you have 8i or DBMS_SQL if you run an older version...

So long,

Jan Received on Tue Jun 18 2002 - 10:41:17 CDT