Re: How execute several operations in a unique script

Hi,

is there an carriage-return betwen the two lines ?

hth Stephan

Ben-oui schrieb:

> 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

--
Mit freundlichen Gr$B|_(Ben

Stephan Langer,
QITS GmbH