Re: Dynamice SQL in Oracle

On Wed, 11 May 2005 09:20:09 +0200, Noel <tbal_at_go2.pll-l> wrote:

>SQL> begin
> 2 execute immediate 'create table t(i number, n varchar(10))';
> 3 execute immediate 'insert into t values(2,''dfg'')';
> 4 execute immediate 'insert into t values(2,''dfg'')';
> 5 execute immediate 'insert into t values(2,''dfg'')';
> 6 execute immediate 'insert into t values(2,''dfg'')';
> 7 execute immediate 'insert into t values(2,''dfg'')';
> 8 end;
> 9 /
>
>Procedura PL/SQL zosta?a zako?czona pomy?lnie.
>
>SQL> select * from t;
>
> I N
>--------- ----------
> 2 dfg
> 2 dfg
> 2 dfg
> 2 dfg
> 2 dfg
>
>SQL>
And has *five* fully unnecessary execute immediates in conjunction with 5 insert statements.
Apparently you don't know only DDL (if you know what that is) requires execute immediate in *PL*/SQL!!!

--
Sybrand Bakker, Senior Oracle DBA