title: How to conditionally select a column in an Oracle query
body: <p>I want to do something like:</p>
  
  <pre><code>select (if lookup = 8 then 08 else lookup) lookup
    , //more columns
  from lookup_table
  order by lookup
  </code></pre>
  
  <p>Unfortunately, Oracle doesn't seem to like this syntax, and I am failing to discover why or find what other function I should be using.</p>
  
  <p>Basically, if the lookup value is 8, I want to get 08, otherwise I want the value of lookup. I'm sure I'm just being stupid.</p>