title: 10g ordering varchar columns when containing numbers in front
body: <p>I have an Oracle 10g DB and have a VARCHAR2 (2000 Character) column lets name it TEST which can contain numbers in front for example:</p>
  
  <pre><code>test
  1test
  3test
  </code></pre>
  
  <p>When I call "... order by TEST asc" or simply "... order by TEST"</p>
  
  <p>I get the results ordered like</p>
  
  <pre><code>test
  1test
  3test
  </code></pre>
  
  <p>But I would like to get the results ordered like this:</p>
  
  <pre><code>1test
  3test
  test
  </code></pre>
  
  <p>So the numbered inserts first, is there a method to achieve this?</p>