Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How execute several operations in a unique script

How execute several operations in a unique script

From: Ben-oui <aslamette_at_free.fr>
Date: Wed, 05 Sep 2001 13:53:44 GMT
Message-ID: <I7ql7.3120$kK2.3057783@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 - 08:53:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US