title: Oracle SQL for handling null values
body: <p>I have a table with 3 columns: c1, c2 and c3.
  I want to write a select statement so that if both c1 and c2 are null, display c3, otherwise display c1.</p>
  
  <p>What would be the best way to write a select statement in the above scenario?</p>