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: tony_becky_mikey_verizon_news <Xyz_at_pdq.com>
Date: Sat, 24 Feb 2007 18:27:20 -0600
Message-ID: <45e0d816$0$28139$4c368faf@roadrunner.com>


How about a commit somewhere??

"Steven Prasil" <prasil_at_nortel.com> wrote in message news:45e0a1c1$0$20287$9b4e6d93_at_newsspool3.arcor-online.net...
>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
>
>



I am using the free version of SPAMfighter for private users. It has removed 104 spam emails to date.
Paying users do not have this message in their emails. Try SPAMfighter for free now! Received on Sat Feb 24 2007 - 18:27:20 CST

Original text of this message

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