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