I am trying to create a table and I am getting the error "ORA-00907: missing right parenthesis".
CREATE TABLE data_create (
studentid NUMBER(9) PRIMARY KEY,
name VARCHAR(25) NOT NULL,
program CHAR(4)
CONSTRAINT check_program
CHECK (program = 'CP', 'CPA', 'CSTC', 'CSTY'),
dob DATE,
email VARCHAR(20)
CONSTRAINT check_email UNIQUE (email),
phone NUMBER(10),
feepaid NUMBER(6)
CONSTRAINT check_feepaid
CHECK (feepaid BETWEEN 0 and 9999.99)
)
I have tried several different things but can't get the error to go away. I am brand new to oracle and am not super familiar with the syntax. Can anyone tell me what I am doing wrong?
Thanks!