Re: Dynamice SQL in Oracle

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 11 May 2005 22:30:40 +0200
Message-ID: <d5tq1b$61i$04$1@news.t-online.com>

Sybrand Bakker schrieb:
> On Wed, 11 May 2005 22:02:39 +0200, Maxim Demenko <mdemenko_at_gmail.com>
> wrote:
>
>

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

>
>
> Nonsense!
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Really ?
What do you think would be a result of

SQL> begin
  2 execute immediate 'create table t(id number)';   3 insert into t values(1);
  4 commit;
  5 end;
  6 /

I assume, it will be an error on line 3...

Best regards

Maxim Received on Wed May 11 2005 - 15:30:40 CDT