I have stared at this until my eyeballs bleed, where am I missing a parenthesis? It does also say
Error starting at line: 1 in command-“.
The cause and action section of the error report is blank.
x
CREATE TABLE EVENTREQUEST( EVENTNO VARCHAR2(8) CONSTRAINT EVENTNO_NOTNULL NOT NULL, DATEHELD DATE CONSTRAINT DATEHELD_NOTNULL NOT NULL, DATEREQ DATE CONSTRAINT DATEREQ_NOTNULL NOT NULL, CUSTNO VARCHAR2(8) CONSTRAINT CUSTNO_NOTNULL2 NOT NULL, FACNO VARCHAR2(8) CONSTRAINT CUSTNO_NOTNULL2 NOT NULL, DATEAUTH DATE, STATUS VARCHAR2(15) CHECK (STATUS IN ('Pending', 'Denied', 'Approved')) CONSTRAINT STATUS_NOTNULL NOT NULL, ESTCOAST VARCHAR2(30) CONSTRAINT ESTCOAST_NOTNULL NOT NULL, ESTAUDIENCE VARCHAR2(30) CHECK(ESTAUDIENCE > 0) CONSTRAINT ESTAUDIENCE_NOTNULL NOT NULL, BUDNO VARCHAR2(8), CONSTRAINT PK_EVENTNO PRIMARY KEY, CONSTRAINT FK_CUSTONO FOREIGN KEY (CUSTNO) REFERENCES CUSTOMER(CUSTNO), CONSTRAINT FK_FACNO FOREIGN KEY (FACNO) REFERENCES FACILITY(FACNO));Advertisement
Answer
This just because you missed column name while declaring primary key. There is another problem: constraint name for both fourth and fifth columns are same. I have changed that too.
And there is no need to declare CONSTRAINT EVENTNO_NOTNULL NOT NULL since you are declaring it as primary key.
CREATE TABLE EVENTREQUEST(EVENTNO VARCHAR2(8) CONSTRAINT EVENTNO_NOTNULL NOT NULL,DATEHELD DATE CONSTRAINT DATEHELD_NOTNULL NOT NULL,DATEREQ DATE CONSTRAINT DATEREQ_NOTNULL NOT NULL,CUSTNO VARCHAR2(8) CONSTRAINT CUSTNO_NOTNULL2 NOT NULL,FACNO VARCHAR2(8) CONSTRAINT FACNO_NOTNULL2 NOT NULL,DATEAUTH DATE,STATUS VARCHAR2(15) CHECK (STATUS IN ('Pending', 'Denied', 'Approved')) CONSTRAINT STATUS_NOTNULL NOT NULL,ESTCOAST VARCHAR2(30) CONSTRAINT ESTCOAST_NOTNULL NOT NULL,ESTAUDIENCE VARCHAR2(30) CHECK(ESTAUDIENCE > 0) CONSTRAINT ESTAUDIENCE_NOTNULL NOT NULL,BUDNO VARCHAR2(8),CONSTRAINT PK_EVENTNO PRIMARY KEY (EVENTNO),CONSTRAINT FK_CUSTONO FOREIGN KEY (CUSTNO) REFERENCES CUSTOMER(CUSTNO),CONSTRAINT FK_FACNO FOREIGN KEY (FACNO) REFERENCES FACILITY(FACNO));