title: How to return multiple values using case statement in oracle
body: <p>I want to return multiple values from a query in oracle. For ex: </p>
  
  <pre><code>select count(*)
  from tablename a 
  where asofdate='10-nov-2009'
  and a.FILENAME in (case 
      when 1 = 1 then (select distinct filename from tablename 
          where asofdate='10-nov-2009' and isin is null) 
      else null
  end);
  </code></pre>
  
  <p>I am getting error: ora 01427 single row subquery returns more than one row</p>
  
  <p>Please advice.</p>
  
  <p>Thanks, Deepak</p>