Re: Batching of SQL commands

Hello Simon,

> If I try the same kind of thing in SQL Plus, for example:
>
> CREATE TABLE FIRST (<table definition>)
> CREATE TABLE SECOND (<table definition>)
> CREATE TABLE THIRD (<table definition>)
>
> I get a "Missing or invalid option" error at the CREATE TABLE SECOND line.
I
> tried wrapping these statements in a BEGIN...END; block but that didn't
help. I
> also get the same kind of problem when batching multiple ALTER TABLE
statements.
>

in Oracle all statements needs a semicolon at the end.

Try

CREATE TABLE FIRST (<table definition>); CREATE TABLE SECOND (<table definition>); CREATE TABLE THIRD (<table definition>);

Arne Received on Thu Aug 01 2002 - 07:25:31 CDT