Re: Dynamice SQL in Oracle

On Wed, 11 May 2005 22:30:40 +0200, Maxim Demenko <mdemenko_at_gmail.com> wrote:

>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

I stand corrected.
However, of course, this piece of code has nothing to do with proper development methods. In Oracle you don't need to create tables on the fly.

--
Sybrand Bakker, Senior Oracle DBA