CODEWITHSUNDEEP
oracle-database
SGIL
SGIL

Reputation: 115

Creating Table that has multiple Foreign Keys in Oracle

I'm trying to create a table of ENCOUNTER entity. I have successfully created all the foreign key tables associated with this table, but when I try to run it on Oracle Database Express Edition 11g, it's keep giving the following error message, and I cannot find any error. ORA-00907: missing right parenthesis Below is the command syntax. 

CREATE TABLE ENCOUNTER (
ENCT_ID VARCHAR2(25) PRIMARY KEY,
ENCT_DATE DATE NOT NULL,
PT_MRN NUMBER NOT NULL,
ENCT_BP VARCHAR2(10) NOT NULL,
ENCT_WT NUMBER(3,2) NOT NULL,
ENCT_TEMP NUMBER(3) NOT NULL,
ACCT_ID VARCHAR2(25) NOT NULL,
PHX_ID VARCHAR2(25) NOT NULL,
CONSTRAINT FK_PATIENT FOREIGN KEY (PT_MRN) REFERENCES PATIENT(PT_MRN)
CONSTRAINT FK_ACCOUNT FOREIGN KEY (ACCT_ID) REFERENCES ACCOUNT(ACCT_ID)
CONSTRAINT FK_PTHISTORY FOREIGN KEY (PHX_ID) REFERENCES PTHISTORY(PHX_ID));

Upvotes: 6

Views: 28310

Answers (1)

jongusmoe
jongusmoe

Reputation: 676

I believe you are missing commas after each constraint. 

CREATE TABLE ENCOUNTER (
ENCT_ID VARCHAR2(25) PRIMARY KEY,
ENCT_DATE DATE NOT NULL,
PT_MRN NUMBER NOT NULL,
ENCT_BP VARCHAR2(10) NOT NULL,
ENCT_WT NUMBER(3,2) NOT NULL,
ENCT_TEMP NUMBER(3) NOT NULL,
ACCT_ID VARCHAR2(25) NOT NULL,
PHX_ID VARCHAR2(25) NOT NULL,
CONSTRAINT FK_PATIENT FOREIGN KEY (PT_MRN) REFERENCES PATIENT(PT_MRN),
CONSTRAINT FK_ACCOUNT FOREIGN KEY (ACCT_ID) REFERENCES ACCOUNT(ACCT_ID),
CONSTRAINT FK_PTHISTORY FOREIGN KEY (PHX_ID) REFERENCES PTHISTORY (PHX_ID));

Upvotes: 9

Related Questions