title: oracle decode with multiple values
body: <p>i want to decode the value like the below query:</p>
  
  <pre><code>select id,
         name,
         val 
    from table1 
   where id in (decode(1,0,0,1,('''4'',''5'',''6''')));
  </code></pre>
  
  <p>But i am getting no records (Records are actually available).
  Is the decode functionality like <code>('''4'',''5'',''6''')</code> will works?</p>
  
  <p>I tried but not working. Any alternative to do so?</p>