title: Case expression in where clause PL/SQL
body: <p>How could I query something like this in PL/SQL?</p>
  
  <pre><code>declare
    l_batch_type number := 1;
  select
    *
  from table t
  where 
    case 
      when l_batch_type = 1 then ('A', 'B')
      when l_batch_type = 2 then ('C', 'D')
      when l_batch_type = 3 then ('E', 'F')
      when l_batch_type is null then null end in t.batch_type;
  </code></pre>
  
  <p>I'm getting SQL Error: ORA-00907: missing right parenthesis
  It is obviously something wrong with ('X','Y') values and in operator,
  but I can't figure out how to match right syntax.</p>
  
  <p>Thanks!</p>