Stuck on Oracle SQL constraint

Question

CREATE TABLE STUDENT (
ST_ID NUMBER(2) PRIMARY KEY NOT NULL,
S_ID NUMBER(2) NOT NULL,
ST_FULL_NAME CHAR(25),
ST_GENDER CHAR(1) NOT NULL,
ST_AGE NUMBER(2),
ST_EMAIL VARCHAR(20) CHECK(ST_EMAIL LIKE ‘%@%’),
ST_GDATE DATE,
FOREIGN KEY (S_ID) REFERENCES STAFF,
CONSTRAINT STUDENT_CK_ST_GENDER CHECK (ST_GENDER IN ('M','F')),
CONSTRAINT STUDENT_CK_ST_GDATE CHECK (ST_GDATE > 01-JAN-2014));  --<-- constraint

I am stuck on the last constraint. Every time I get a message saying "JAN" invalid identifier.

Can anybody please identify the mistake and correct it for me?

Use the quote in this way: '01-JAN-2014'

Joe Taras
– Joe Taras

2014-03-21 21:43:54 +00:00
Commented Mar 21, 2014 at 21:43 — Joe Taras
– Joe Taras, Commented Mar 21, 2014 at 21:43

Andrew · Accepted Answer · 2014-03-21 21:43:29Z

4

CONSTRAINT STUDENT_CK_ST_GDATE CHECK (ST_GDATE > TO_DATE('20140101','YYYYMMDD'))

answered Mar 21, 2014 at 21:43

Andrew

27.4k5 gold badges67 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3448236 Over a year ago

THANKS, YOU HAVE BEEN A GREAT HELP. IV BEEN STUCK IN THIS FOR AGES.

Collectives™ on Stack Overflow

Stuck on Oracle SQL constraint

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related