Re: Dynamice SQL in Oracle

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 11 May 2005 22:02:39 +0200
Message-ID: <d5tocr$e6c$00$1@news.t-online.com>

Sybrand Bakker schrieb:
> 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

As the table t was created with execute immediate, he didn't have another choice ;-)

Best regards

Maxim Received on Wed May 11 2005 - 15:02:39 CDT