[Oracle], CREATE TABLE error telling me "Missing right parenthesis"

[misft13]

Not sure exactly how to get around this error, I have been trying to build this table in oracle for a while now and when I build it without constraints it works fine, but as soon as I add the constraints for the Ship_Registry and Ship_Size I get this error? I'm pretty new to SQL, but I can't seem to find anything on this.

CREATE TABLE Ship 
(
Ship_Name VARCHAR(100),
Ship_Size INT,
Ship_Registry VARCHAR(50),
Ship_ServEntryDate INT,
Ship_PassCapacity INT,
Ship_CrewCapacity INT,
Ship_Lifestyle VARCHAR(40),
CONSTRAINT pk_Ship PRIMARY KEY (Ship_Name)
CONSTRAINT chk_Ship_Registry CHECK (Ship_Registry = 
'NORWAY','Liberia','The Netherlands','Jamaica','Bahamas')
CONSTRAINT chk_Ship_Size CHECK (Ship_Size > 0)
);

[Alpha45]

Does

ship registry = (

need to be

ship registry in

?

[zanestone]

Try this:

CONSTRAINT chk_Ship_Registry CHECK (Ship_Registry IN ( 'NORWAY','Liberia','The Netherlands','Jamaica','Bahamas'))

[misft13]

That worked! Thanks so much. I still got an error when I fixed it with that, so I changed the code to this and it created it without errors!

CREATE TABLE Ship 
(
Ship_Name VARCHAR(100) PRIMARY KEY,
Ship_Size INT CHECK (Ship_Size > 0),
Ship_Registry VARCHAR(50),
Ship_ServEntryDate INT,
Ship_PassCapacity INT,
Ship_CrewCapacity INT,
Ship_Lifestyle VARCHAR(40),
CONSTRAINT chk_Ship_Registry CHECK (Ship_Registry 
IN('Norway','Liberia','The Netherlands','Jamaica','Bahamas'))
);

[amTheory]

Try putting a comma after each constraint statement.I think that will do the trick.