CODEWITHSUNDEEP
sqloracle-database
Zarch
Zarch

Reputation: 133

Oracle SQL-ALTER TABLE Error

I've been looking over the following SQL code for awhile and just can't seem to find the problem. I'm relatively new to SQL, so I'm sure it's just something I'm overlooking. The error message I get is: ORA-01735: Invalid ALTER TABLE option.

Code:

ALTER TABLE PATIENT
(
ADD CONSTRAINT PProfileForeignKey
    FOREIGN KEY (pProfileID) REFERENCES PATIENT_PROFILE(Profile_ID),
ADD CONSTRAINT InsForeignKey
    FOREIGN KEY (pInsID) REFERENCES INSURANCE(Insurance_ID)
        ON DELETE SET NULL
);

I have triple checked to make sure the foreign key column names and the referenced column names are correct.

Upvotes: 1

Views: 507

Answers (1)

ScaisEdge
ScaisEdge

Reputation: 133400

seems The parentheses are in wrong place 

ALTER TABLE PATIENT
 ADD (CONSTRAINT PProfileForeignKey
    FOREIGN KEY (pProfileID) REFERENCES PATIENT_PROFILE(Profile_ID),
    CONSTRAINT InsForeignKey
    FOREIGN KEY (pInsID) REFERENCES INSURANCE(Insurance_ID)
        ON DELETE SET NULL);

Upvotes: 1

Related Questions