Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> syntax problem creating more than one table in a sql script
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
![]() |
![]() |