Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Putting multiple CREATE TABLE statements in one *.SQL is really not possible ?
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.
-- JeroenReceived on Sat Feb 24 2007 - 17:55:34 CST
![]() |
![]() |