1以下数字Oracle打印缺少0,Oracle SQL中缺少關鍵字

我收到以下錯誤：

ORA-00905: missing keyword

00905. 00000 - "missing keyword"

我的SQL：

CREATE Table ORDERDET

(

ORDERID NUMBER,

CUSTID NUMBER,

PRODID NUMBER,

ORDPRIORITY VARCHAR2(15),

ORDDISCOUNT NUMBER(3,2),

ORDSHIPMODE VARCHAR2(15),

ORDDATE DATE,

ORDSHIPDATE DATE,

ORDSHIPCOST NUMBER(5,2),

ORDQTY NUMBER,

ORDSALES NUMBER(7,2),

CONSTRAINT ch_ORDPRIORITY

CHECK (ORDPRIORITY IN ('Low', 'Medium', 'High', 'Critical', 'Not Specified')),

CONSTRAINT ch_ORDSHIPMODE

CHECK (ORDSHIPMODE IN ('Regular Air','Delivery Truck','Express Air')),

CONSTRAINT pk_ORDERDET

PRIMARY KEY (ORDERID, CUSTID, PRODID),

CONSTRAINT fk_ORDERD

FOREIGN KEY (ORDERID) REFERENCES ORDERS (ORDERID) on DELETE RESTRICT,

CONSTRAINT fk_CUSTOMERORDER

FOREIGN KEY (CUSTID) REFERENCES CUSTOMERS (CUSTID) on DELETE RESTRICT,

CONSTRAINT fk_PRODUCTORDER

FOREIGN KEY (PRODID) REFERENCES PRODUCTS (PRODID) on DELETE RESTRICT

);

+0

'ORA-00905：缺少關鍵字00905. 00000 - 「缺少關鍵字」'整個消息？是否還有行號？ –

+2

註釋掉你所有的約束。嘗試創建表格。放下桌子，然後再次嘗試添加一個約束。注意你的逗號和右括號。 –

+0

從一開始就有一個「錯誤始於行：641 in命令 - 」。 –