title: Is it possible to use CASE with ANY() in Oracle SQL?
body: <p>Is possible to achieve what I'm trying to do in the below SQL query?
  I want to check if the item name matches any of the given list.</p>
  
  <pre><code>select
    case item_name
      when any ('PEN', 'PENCIL', 'PAPER', 'ERASER') then 'STATIONARY'
      else 'OTHER'
    end is_stationary
  from items;
  </code></pre>
  
  <p>I tried this query, and seems it is not possible. The error message is,</p>
  
  <pre><code> ORA-00936: missing expression
   00936. 00000 -  "missing expression"
   *Cause:    
   *Action:
   Error at Line: 29 Column: 10
  </code></pre>
  
  <p>Is there any other workaround to achieve this?</p>