title: PL/SQL returning a list in a CASE statement
body: <p>I need a CASE statement to return a list of strings but I'm having some syntax problems. The resulting SQL should be something like this:</p>
  
  <pre><code>SELECT * FROM FRUIT WHERE COLOR IN ('RED', 'YELLOW')
  </code></pre>
  
  <p>What I'm trying to do (this doesn't work):</p>
  
  <pre><code>SELECT * FROM FRUIT WHERE COLOR IN
  CASE
      WHEN TYPE = *something*
      THEN ('RED', 'YELLOW')
      ELSE ('GREEN')
  END
  </code></pre>
  
  <p>This works:</p>
  
  <pre><code>SELECT * FROM FRUIT WHERE COLOR IN
  CASE
      WHEN TYPE = 1
      THEN 'RED'
      ELSE 'GREEN'
  END
  </code></pre>
  
  <p>The error I'm getting:</p>
  
  <pre><code>ORA-00907 missing right parenthesis
  </code></pre>
  
  <p>It works when I use multiple COLOR = 'X' OR COLOR = 'Y' but I was wondering if there was a way to use only one CASE statement for that. Thanks in advance.</p>