I think I've found a bug in Oracle SQL developer. For some reason I get the error message "Right parenthesis is missing" whenever I put NOT NULL before date and it only happens on this particular table, it works perfectly well to do the same elsewhere. Looking at the code there don't appear to be any parenthesis missing so what is causing this error and why does it only happen when NOT NULL is put before date?
CREATE TABLE REVIEW(
AcademicID NOT NULL REFERENCES ACADEMIC (AcademicID) ON DELETE CASCADE,
ArticleID NOT NULL REFERENCES ARTICLE (ArticleID) ON DELETE CASCADE,
CONSTRAINT Review_pk PRIMARY KEY (AcademicID, ArticleID),
ReviewDate NOT NULL date