sql creating table with constraints

Question

When I'm run this code getting error saying,

SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword"

*Cause:
*Action: Running it on ORACLE. Not sure how to fix it.

CREATE TABLE LAB4 (
  ROOMID1 NUMBER(8) NOT NULL,
  BUILDING1 VARCHAR2(25) NOT NULL,
  ROOMNO1 VARCHAR2(25) NOT NULL,
  CONSTRAINT ROOMPK1 PRIMARY KEY(ROOMID1));

CREATE TABLE BOOKING (
  BOOKINGID NUMBER(4) NOT NULL ,
  DAYOFWEEK CHAR(15) NOT NULL,
  TIMEOFDAY CHAR(8) NOT NULL,
  DURATION VARCHAR2(20)NOT NULL,
  UNITCODE NUMBER(8)NOT NULL,
  ROOMID NUMBER(4) NOT NULL, 
  CONSTRAINT BOOKINGPK PRIMARY KEY(BOOKINGID),
  CONSTRAINT LABFK FOREIGN KEY(ROOMID)
    REFERENCES LAB(ROOMID)
     ON UPDATE NO ACTION
    ON DELETE NO ACTION
  );

The table is called LAB4, but you are referencing LAB.

GolezTrol
– GolezTrol

2015-09-14 08:32:40 +00:00
Commented Sep 14, 2015 at 8:32 — GolezTrol
– GolezTrol, Commented Sep 14, 2015 at 8:32

Cristian Veronesi · Accepted Answer · 2015-09-14 08:39:06Z

2

ON UPDATE NO ACTION ON DELETE NO ACTION is definitely not Oracle syntax.

Please check out the appropriate Oracle documentation (according to the version you are using - you didn't provide an Oracle version number).

The only allowed options in latest Oracle versions are:

ON DELETE CASCADE / ON DELETE SET NULL

edited Sep 14, 2015 at 8:39

answered Sep 14, 2015 at 8:35

Cristian Veronesi

3101 gold badge4 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql creating table with constraints

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related