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 -> Re: Putting multiple CREATE TABLE statements in one *.SQL is really not possible ?

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

From: The Boss <usenet_at_No.Spam.Please.invalid>
Date: Sun, 25 Feb 2007 00:55:34 +0100
Message-ID: <12u1k3n48io2c36@corp.supernews.com>


DA Morgan wrote:
> Steven Prasil wrote:
>> 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 ?
>>
>> Even when I append a semicolon after each CREATE TABLE statement it
>> does not run. Is this really not possible ?
>>
>> Steven
>
> In TOAD.

Also possible in TOAD with the "Run as a script" function.

-- 
Jeroen 
Received on Sat Feb 24 2007 - 17:55:34 CST

Original text of this message

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