title: Oracle sql order by with character in order
body: <p>Good day, Maybe someone can help me , i want to get n select output on oracle sql , but when i order by it is not correct.</p>
  
  <pre><code>code_order
  1.
  2.
  2.1
  3.
  4.2
  10.1
  10.0
  21.
  21.1
  23.
  31.
  </code></pre>
  
  <p>it needs to be ordered numeric and all values has a full stop in<code>.</code></p>
  
  <p>any ideas??</p>
  
  <p>Thanx, but i see that some values can contain non numeric values as well like C,B etc.</p>
  
  <p><ol>
  <li><ol>
  <li><ol>
  <li><ol>
  <li><ol>
  <li><ol>
  <li><ol>
  <li><ol>
  <li><ol>
  <li><ol>
  <li>7C. 40. 50. 51. 6.</li>
  </ol></li>
  </ol></li>
  </ol></li>
  </ol></li>
  </ol></li>
  </ol></li>
  </ol></li>
  </ol></li>
  </ol></li>
  </ol>
  Table outline :</p>
  
  <p>code_order is varchar2</p>