title: I have an informatica code.I want to have an equivalent of the same in oracle query
body: <pre><code>IIF(Col1=1, DAT1, IIF(Col2=1, DAT2, IIF(col3=1, DAT3, IIF(Col4=1, DAT4)))) 
  </code></pre>
  
  <p>The above is the informatica piece of code</p>
  
  <p>How do i convert this in oracle</p>
  
  <pre><code>case when col1=1 then data1
   else
   case when col2=1 then data2)
  </code></pre>
  
  <p>I have tried something like this.But i am not sure .Please suggest me on how to convert</p>