title: Using if condition in the Select statement
body: <p>I am trying to use the if condition in the select query of the Oracle database. The columns should be set to some value depending on the value like the below is what I tried</p>
  
  <pre><code>Select if(expvalue.DATA = '0','Unpublished','Published') as STATUS from
  </code></pre>
  
  <p>DATA field is a Boolean so I want to set the Status to be Unpublished if the Boolean is 0 and published if it is 1.But the above syntax gives error like</p>
  
  <p><code>ORA-00907: missing right parenthesis
  00907. 00000 -  "missing right parenthesis"</code></p>