title: Case in Oracle WHERE clause
body: <p>Following oracle query complies and works fine:</p>
  
  <pre><code>SELECT
      Employee.EmployeeId,
      Employee.EmployeeName,
      Employee.Description,
      Employee.IsFrozen 
  FROM
      employee, employeerole, roledef
  WHERE
      employee.employeeid = employeerole.employeeid 
      AND employeerole.roleid = roledef.roleid
      AND rolename IN (
                      CASE
                          WHEN (1 &lt; 2)  THEN ('Owner Role')
                          WHEN (2 &lt; 1)  THEN ('Eval Owner Role')
                      END);
  </code></pre>
  
  <p>Now in my case I would like to add in second when ie (2 &lt; 1) two rolename('Owner Role' and 'Eval Owner Role'). 
  Kindly suggest how will the above query change.</p>
  
  <p>Thanks in advance.</p>
  
  <p>-Justin Samuel</p>