0
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 
);
a_horse_with_no_name
  • 497,550
  • 91
  • 775
  • 843

1 Answers1

0

There is no such thing as ON UPDATE CASCADE in Oracle. There might be in other RDMBSs, but not Oracle. Take that clause out.

eaolson
  • 14,065
  • 7
  • 40
  • 54