title: How to define a check constraint with OR condition
body: <p>I just want to restrict values in player_position when inserting data in the table.</p>
  
  <pre><code>Create Table PLAYERS
  (Player_Id NUMBER(4),Player_First_Name VARCHAR(15),Player_Last_Name VARCHAR(15),Player_Team_Code CHAR(3),
  Player_Position CHAR(2),
  CONSTRAINT Player_Position_check CHECK (Player_position = 'QB' or 'RB' or 'WR' or 'DB' or 'LB' or 'OT' or 'DT' or 'PT' or 'KI')
  CONSTRAINT Player_Id_PK PRIMARY KEY (Player_Id));
  </code></pre>
  
  <p>what is wrong with this code ?</p>