title: CASE condition with IN clause in Oracle
body: <p>I am trying to pass the in clause after case statement but facing error.</p>
  
  <p>Condition is </p>
  
  <pre><code>AND (CASE order_date&gt;sysdate 
        then fee_rate_type in ('REGULAR','BONUS')
        ELSE FEE_RATE_TYPE in ('REGULAR') END)
  </code></pre>
  
  <p>When i am passing single value instead of multiple (pass 'BONUS' insted of 'REGULAR','BONUS') then its working fine.</p>
  
  <p>table structure:</p>
  
  <pre><code>ID  fee_rate    order_date
  --  --------    ----------
  1   REGULAR     02/02/2016
  2   BONUS       02/02/2016
  3   BONUS       02/02/2016
  4   BONUS       02/02/2016
  5   PROMO       02/02/2016
  6   PROMO       02/02/2016
  </code></pre>
  
  <p>Please assist.</p>