Re: Putting multiple CREATE TABLE statements in one *.SQL is really not possible ?

Steven Prasil wrote on 24.02.2007 21:36:
> I put a couple of CREATE TABLE statements into one sql sheet/file similar to:
>
> CREATE TABLE A ( ..... )
>
> CREATE TABLE B ( ..... )
>
> CREATE TABLE C ( ..... )
>
> and try to run them against an Oracle database. However Oracle resp. Toad/SQL Editor
> told me "Invalid option". Why ?

What do you mean with "Oracle ... told me"? Which Oracle Tool did you use to run this file?

SQL*Plus will certainly run multiple CREATE TABLE statements in a single SQL file if delimited correcly.

> Even when I append a semicolon after each CREATE TABLE statement it does not run.
SQL Statements are always delimited with a semicolon. So you should have done that from the beginning. SQL*Plus will allow you to use an alternate delimiter (the default is a forward slash) as well, but his is a tool specific extension to the SQL language.

> Is this really not possible ?

If Toad doesn't run this, then it's a TOAD problem not an Oracle problem Received on Sat Feb 24 2007 - 14:42:13 CST