title: comparing using multiple arguments in the Lower/Upper function
body: <p>I am trying to implement a query like below</p>
  
  <pre><code>        SELECT *
          FROM   emp
          WHERE  LOWER (ename) IN LOWER ('A', 'b', 'C', 'd','eF','GG','Hh');
  </code></pre>
  
  <p>but getting error</p>
  
  <pre><code> ORA-00909: invalid number of arguments.
  </code></pre>
  
  <p>Is there any specific function by which I can compare multiple arguments in the 'IN' clause having lower case?</p>