oracle - Oracle SQL 表在 Create 语句上显示缺少右括号为什么？

Question

CREATE TABLE Edit 
(
    editID numeric(5) PRIMARY KEY , 
    CONSTRAINT edit_fk FOREIGN KEY (adminID)
         REFERENCES Admin (adminID)
              ON DELETE CASCADE
              ON UPDATE CASCADE,
    CONSTRAINT edit_fk FOREIGN KEY (flgihtID)
         REFERENCES Flight (flightID)
              ON DELETE CASCADE
              ON UPDATE CASCADE
);

CREATE TABLE Reservation 
(
    reservationID numeric(5) PRIMARY KEY,
    CONSTRAINT reservation_fk FOREIGN KEY (flightID)
         REFERENCES Flight (flightID)
              ON DELETE CASCADE
              ON UPDATE CASCADE 
);

标签： oracleddlcreate-table

Answer 1

ON UPDATE CASCADE在 Oracle中没有这样的东西。其他 RDMBS 中可能有，但 Oracle 中没有。把那个条款去掉。