title: Oracle Condition inside IN CLAUSE
body: <p>Hi I am writing oracle query to support select all for in clause my query goes something like this</p>
  
  <pre><code>SELECT * FROM country
  WHERE 
  country_id in( IF('test' = 'test',(1,2,3),true) )
  </code></pre>
  
  <p>If condition ('test' = 'test') is true then it should fire query like</p>
  
  <pre><code>SELECT * FROM country WHERE  country_id in(1,2,3)
  </code></pre>
  
  <p>Else it should fire query</p>
  
  <pre><code> SELECT * FROM country WHERE  country_id in(true)
  </code></pre>