title: oracle equivalent of mysql ifnull (no case, no if)
body: <p>I am looking for a quick way to do</p>
  
  <pre><code>SELECT IFNULL(columna, columnb) FROM mytable
  </code></pre>
  
  <p>(I have dozens of columns and don't want to write a case for each of them)</p>