title: Cannot Create Table in SQL with CHECK constraint
body: <p>I am trying to create a new table in SQL developer. I need to have a CHECK constraint on for Clinic_City, however it will not work. Can anybody help me? </p>
  
  <pre><code>CREATE TABLE TravelClinics (Clinic_Number number(3) PRIMARY KEY,
  Clinic_Street varchar2(20) NOT NULL,
  Clinic_City varchar2(10) NOT NULL,
  Clinic_County varchar2(15) NOT NULL,
  Clinic_Postcode varchar2(7) NOT NULL,
  Clinic_Tel varchar2(11) NOT NULL,
  Clinic_Fax varchar2(11) NOT NULL
  CONSTRAINT
  CHECK(Clinic_City IN ('LONDON', 'BIRMINGHAM', 'MANCHESTER', 'LEEDS', 'GLASGOW', 'EDINBURGH')))
  </code></pre>