title: How to order by field mixed with string and number in Oracle?
body: <p>These are the field (crane_no) values to be sorted
  <br>QC11<br>QC10<br>QC9</p>
  
  <p>I tried the following query:</p>
  
  <pre><code>select * from table order by crane_no DESC
  </code></pre>
  
  <p>but query results does not give in an order because the field is mixed with staring and number (Example:<strong>QC12</strong>). 
  I get following results for above query:
  <br>QC9<br>QC11<br>QC10
  <br><br>I want the results to be in order (QC9, QC10, QC11). Thanks</p>