OraFAQ Forum: SQL & PL/SQL » Help for a noobie!

Home » SQL & PL/SQL » SQL & PL/SQL » Help for a noobie!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help for a noobie! [message #683102]

Thu, 03 December 2020 01:39

nail3r
Messages: 1
Registered: December 2020

Junior Member

I'm trying to create a table with the following PK's and FK's:

CREATE TABLE result (

SubjectNo varchar2( Cool

,
StudentNo varchar2( Cool

,
Result varchar2(1) CONSTRAINT res_res_passfail_ck CHECK
(result IN ('P','F')),
CONSTRAINT res_subno_studno_pk PRIMARY KEY(SubjectNo, StudentNo),
CONSTRAINT res_subno_fk FORIEGN KEY(SubjectNo)
REFERENCES subject(SubjectNo),
CONSTRAINT res_studno_fk FORIEGN KEY(StudentNo)
REFERENCES student(StudentNo));

I keep getting the error message ORA-00907: missing right parenthesis. Can anyone tell me what I've gotten wrong?

Report message to a moderator

Re: Help for a noobie! [message #683105 is a reply to message #683102]

Thu, 03 December 2020 04:17

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

SQL> CREATE TABLE result (
  2    SubjectNo varchar2(8),
  3    StudentNo varchar2(8),
  4    Result varchar2(1) CONSTRAINT res_res_passfail_ck CHECK (result IN ('P','F')),
  5    CONSTRAINT res_subno_studno_pk PRIMARY KEY(SubjectNo, StudentNo),
  6    CONSTRAINT res_subno_fk FORIEGN KEY(SubjectNo) REFERENCES subject(SubjectNo),
  7    CONSTRAINT res_studno_fk FORIEGN KEY(StudentNo) REFERENCES student(StudentNo));
  CONSTRAINT res_subno_fk FORIEGN KEY(SubjectNo) REFERENCES subject(SubjectNo),
                                     *
ERROR at line 6:
ORA-00907: missing right parenthesis

FORIEGN <> FOREIGN

Report message to a moderator

Previous Topic:	Need help to rewrite the query
Next Topic:	string_api package that... has no body?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 30 07:29:47 CDT 2023