求助
CREATE TABLE Purchases
(cid NUMBER(9,0),
bookId NUMBER(9,0)
CONSTRAINT C2 REFERENCES Books (bookId)
ON DELETE CASCADE,
pdate DATE,
pprice NUMBER(8,2),
CONSTRAINT C1 PRIMARY KEY(cid, bookId),
CONSTRAINT C3 FOREIGN KEY(cid) REFERENCES Customers(cid)
ON DELETE NO ACTION
);
ON DELETE NO ACTION
*
第 10 行出现错误:
ORA-00905: 缺失关键字
CREATE TABLE Purchases
(cid NUMBER(9,0),
bookId NUMBER(9,0)
CONSTRAINT C2 REFERENCES Books (bookId)
ON DELETE CASCADE,
pdate DATE,
pprice NUMBER(8,2),
CONSTRAINT C1 PRIMARY KEY(cid, bookId),
CONSTRAINT C3 FOREIGN KEY(cid) REFERENCES Customers(cid)
ON DELETE NO ACTION
);
ON DELETE NO ACTION
*
第 10 行出现错误:
ORA-00905: 缺失关键字