Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> syntax problem creating more than one table in a sql script

syntax problem creating more than one table in a sql script

From: Robert Prell <RPrell_at_PacBell.Net>
Date: Fri, 13 Nov 1998 20:03:46 GMT
Message-ID: <36508f86.7062511@news.pacbell.net>


I want to create multiple sql tables with a script. If I do;

create table scott.test (field char(20));

this works, but with the same sql script I want to create two or more tables, can someone help me with this. The following does not work.

create table scott.test (field char(20)); create table scott.test2 (field char(20));

or
create table scott.test (field char(20)) create table scott.test2 (field char(20));

does not work either.
Any help would be apreciated. Received on Fri Nov 13 1998 - 14:03:46 CST

Original text of this message

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