Re: How execute several operations in a unique script

From: Stephan Bressler <agadir_at_web.de>
Date: Wed, 5 Sep 2001 16:23:48 +0200
Message-ID: <9n5chp$603$1@news.mch.sbs.de>

Hi,
I tried it on solaris / 8.0.6. No problems there. Maybe there is a hidden character after ';'?

Try re-typing.

Stehan

"Ben-oui" <aslamette_at_free.fr> schrieb im Newsbeitrag news:I7ql7.3120$kK2.3057783_at_nnrp4.proxad.net...
> I would know how I can execute several DDL instructions in a unique script
?
> My Oracle do an ORA-00911 error when I finish my line by a ';'.
>
> ex:
> CREATE TABLE EMP (TOTO VARCHAR2(5));
> ALTER TABLE EMP ADD (TOTO2 NUMBER(5));
>
> An error occur on the ';' of the first line.
> How can I do ?
>
> Thanks
>
>
Received on Wed Sep 05 2001 - 09:23:48 CDT