title: Oracle: How can I implement a "natural" order-by in a SQL query?
body: <p>e.g,</p>
  
  <pre><code>foo1
  foo2
  foo10
  foo100
  </code></pre>
  
  <p>rather than</p>
  
  <pre><code>foo1
  foo10
  foo100
  foo2
  </code></pre>
  
  <p>Update: not interested in coding the sort myself (although that's interesting in its own right), but having the database to do the sort for me.</p>