title: Oracle order by upper(colname) does not give proper results for non string columns
body: <p>When there is a non-string(i.e. : varchar,date) column(col1) in oracle db, if I do:</p>
  
  <pre><code>select * from table order by col1 asc
  </code></pre>
  
  <p>it orders properly. (ie. for date, it orders from oldest to latest, for numeric, from lowest to highest)
  But if i do, <code>select * from table order by upper(col1) asc</code>
  the ordering is not correct.</p>
  
  <p>What is the cause for this behavior?</p>