title: oracle check constraint "in" clause and "like" clause
body: <p>I would like to know what is the different between 'in' clause and 'like' clause oracle in check constraint.</p>
  
  <p>here is sample code for 'in' clause</p>
  
  <pre><code>ALTER TABLE EXPREPORT
  ADD CONSTRAINT EXPREPORT_CHK1 CHECK 
  (EXPREPSTATUS IN ('PENDING', 'APPROVED', 'DENIED'))
  ENABLE;
  </code></pre>
  
  <p>here is sample code for 'like' clause</p>
  
  <pre><code>ALTER TABLE EXPENSEREPORT
  ADD CONSTRAINT EXPENSEREPORT_CHK1 CHECK 
  (EXPREPSTATUS LIKE 'APPROVED' OR EXPREPSTATUS LIKE 'DENIED' OR EXPREPSTATUS LIKE 'PENDING')
  ENABLE;
  </code></pre>
  
  <p>is there any difference between these two clause?</p>