|
Still getting the same error...
Table command:
CREATE TABLE IS_QUALIFIED
(FACULTY_ID INTEGER NOT NULL,
COURSE_ID VARCHAR2(8) NOT NULL,
DATE_QUALIFIED VARCHAR2(10) NOT NULL,
CONSTRAINT IS_QUALIFIED_PK PRIMARY KEY (FACULTY_ID, COURSE_ID),
CONSTRAINT IS_QUALIFIED_FK FOREIGN KEY (FACULTY_ID) REFERENCES FACULTY (FACULTY_ID),
CONSTRAINT IS_QUALIFIED_FK2 FOREIGN KEY (COURSE_ID) REFERENCES COURSE (COURSE_ID));
Load command:
INSERT INTO IS_QUALIFIED
VALUES (2143, 'ISM 3112', '1988-09-01');
INSERT INTO IS_QUALIFIED
VALUES (2143, 'ISM 3113', '1988-09-01');
INSERT INTO IS_QUALIFIED
VALUES (3487, 'ISM 4212', '1995-09-01');
INSERT INTO IS_QUALIFIED
VALUES (3487, 'ISM 4930', '1996-09-01');
INSERT INTO IS_QUALIFIED
VALUES (4756, 'ISM 3113', '1991-09-01');
INSERT INTO IS_QUALIFIED
VALUES (4756, 'ISM 3112', '1991-09-01');
they are all in the correct order also..
__________________
FreeTicketCash - Everyone likes to signup for a free ticket, wide variety of free e-mail sites!
DatingGold - 1$ per email dating site, also per signup.
|