SQL
-
Can anyone tell me what I am doing wrong? I am getting an error message on line 9 (Locid)... Create table Course_Section ( Csecid NUMBER(8) CONSTRAINT PK_COURSE_SECTION PRIMARY KEY, Cid NUMBER(6) NOT NULL CONSTRAINT FK_COURSE_SECTION REFERENCES COURSE(Cid), Termid NUMBER(5) NOT NULL CONSTRAINT FK_COURSE_SECTION REFERENCES TERM(Termid), Secnum NUMBER(5) NOT NULL, Fid NUMBER(4) CONSTRAINT FK_COURSE_SECTION REFERENCES FACULTY(Fid), Day VARCHAR(10) Locid NUMBER(5) CONSTRAINT FK_COURSE_SECTION REFERENCES FACULTY(Locid), Maxenrl NUMBER(4) NOT NULL, Currenrl NUMBER(4) NOT NULL, );
-
Can anyone tell me what I am doing wrong? I am getting an error message on line 9 (Locid)... Create table Course_Section ( Csecid NUMBER(8) CONSTRAINT PK_COURSE_SECTION PRIMARY KEY, Cid NUMBER(6) NOT NULL CONSTRAINT FK_COURSE_SECTION REFERENCES COURSE(Cid), Termid NUMBER(5) NOT NULL CONSTRAINT FK_COURSE_SECTION REFERENCES TERM(Termid), Secnum NUMBER(5) NOT NULL, Fid NUMBER(4) CONSTRAINT FK_COURSE_SECTION REFERENCES FACULTY(Fid), Day VARCHAR(10) Locid NUMBER(5) CONSTRAINT FK_COURSE_SECTION REFERENCES FACULTY(Locid), Maxenrl NUMBER(4) NOT NULL, Currenrl NUMBER(4) NOT NULL, );
-
Can anyone tell me what I am doing wrong? I am getting an error message on line 9 (Locid)... Create table Course_Section ( Csecid NUMBER(8) CONSTRAINT PK_COURSE_SECTION PRIMARY KEY, Cid NUMBER(6) NOT NULL CONSTRAINT FK_COURSE_SECTION REFERENCES COURSE(Cid), Termid NUMBER(5) NOT NULL CONSTRAINT FK_COURSE_SECTION REFERENCES TERM(Termid), Secnum NUMBER(5) NOT NULL, Fid NUMBER(4) CONSTRAINT FK_COURSE_SECTION REFERENCES FACULTY(Fid), Day VARCHAR(10) Locid NUMBER(5) CONSTRAINT FK_COURSE_SECTION REFERENCES FACULTY(Locid), Maxenrl NUMBER(4) NOT NULL, Currenrl NUMBER(4) NOT NULL, );
You have missed the , above the Locid try this hope this will help you.