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 -> Help with SQL script

Help with SQL script

From: Squid <exceldude2001_at_yahoo.com>
Date: 26 Jul 2005 19:17:20 -0700
Message-ID: <1122430640.451756.135670@o13g2000cwo.googlegroups.com>


I am a newbie at Oracle. I need help figuring out when I run the following script (createtables.sql) to create tables. I also included the errors I am receiving under these scripts. I am stumped on why tables are not being created.

TIA
Mike


CREATE TABLE CustType(
CustTypeNum char(3) primary key,
TypeDesc varchar2(30) not null
);

CREATE TABLE Customer(
CustNum number(5,0) primary key,
CustTypeNum char(3) not null,
CustName varchar2(30) not null,
EIN number(9,0),
ShipAddress1 varchar2(30) not null,
ShipAddress2 varchar2(30) not null,
ShipCity varchar2(20) not null,
ShipState char(2) not null,
ShipZip varchar(9) not null,
BillAddress1 varchar2(30) not null,
BillAddress2 varchar2(30) not null,
BillCity varchar2(20) not null,
BillState char(2) not null,
BillZip varchar(9) not null,
constraint FKCustType foreign key(CustTypeNum)

        references CustType(CustTypeNum)
);

CREATE TABLE PriceList(
BasePriceCode number(4,0) primary key,
BasePrice number (7,2) not null
);

CREATE TABLE Drawings(
DrawingNum number(5,0) primary key,
CustNum number(5,0) not null,
CustPartNum number(10,0) not null,
BasePriceCode number(4,0) not null,
DrawingDesc varchar2(30) not null,
DateRecvd date not null,
constraint FKCustNum foreign key(CustNum)

        references Customer(CustNum),
constraint FKBasePrice foreign key(BasePriceCode)

        references PriceList(BasePriceCode)
);

CREATE TABLE Packing List(
PackingListNumber number(5,0) primary key, CustPurchOrder number(10,0) not null,
DateOrdered date not null,
DateAckn date not null,
DrawingNum number(5,0) not null,
CustPartNum number(10,0) not null,
DateSched date not null,
constraint FKCustNum foreign key(CustNum)

        references Customer(CustNum),
constraint FKDrawingNum foreign key(DrawingNum)

        references Drawings(DrawingNum)
);

CREATE TABLE RevisionLevel(
DrawingNum number(5,0) primary key,
OptionNum number(3,0) unique,
Units number (5,2),
CustType char(3)
);

CREATE TABLE Schedule(
RefNum number(6,0) primary key,
PackingListNumber number(5,0) not null,
TransCode char(1) not null,
LaborOptionNum char(1) not null,
Qty number(5,2) not null,
Cost number(5,2) not null,
TubeNum char(5) not null,
TCNum char(5) not null,
constraint FKPackingListNumber foreign key(PackingListNumber)

        references Packing List(PackingListNumber)
);

CREATE TABLE Time Card(
TCNum char(5) primary key,
LineNum char(5) unique,
EmpNum char(5) not null,
Date date not null,
LaborOptionNum char(1) not null,
PackingListNumber number(5,0) not null,
Qty number(5,2) not null
);

CREATE TABLE Transactions(
TranCode char(1) primary key,
Type varchar2(10) not null
);

CREATE TABLE Tubes(
TubeNum char(5) primary key,
Cost number(5,2) not null
);


Here is the script output after I run the scripts: SQL> @createtables.sql
CREATE TABLE CustType(

             *
ERROR at line 1:
ORA-00955: name is already used by an existing object

Table created.

Table created.

constraint FKCustNum foreign key(CustNum)

           *
ERROR at line 8:
ORA-02264: name already used by an existing constraint

CREATE TABLE Packing List(

                     *

ERROR at line 1:
ORA-00922: missing or invalid option

Table created.

        references Packing List(PackingListNumber)
                           *

ERROR at line 11:
ORA-00907: missing right parenthesis

CREATE TABLE Time Card(

                  *

ERROR at line 1:
ORA-00922: missing or invalid option

Table created.

Table created. Received on Tue Jul 26 2005 - 21:17:20 CDT

Original text of this message

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