title: Alphanumeric sorting in Oracle
body: <p>I am selecting the column names from a table with the following query.</p>
  
  <pre><code>SELECT column_name FROM   all_tab_cols
  WHERE  table_name = 'TBL1' AND column_name like 'INFORMATION%'
  order by column_name
  </code></pre>
  
  <p>The resultset is like </p>
  
  <pre><code>INFORMATION1
  INFORMATION10
  INFORMATION11
  INFORMATION12
  .
  .
  .
  INFORMATION2
  INFORMATION20
  </code></pre>
  
  <p>Now, I want it to be sorted like </p>
  
  <pre><code>INFORMATION1
  INFORMATION2
  INFORMATION3
  INFORMATION4
  .
  .
  .
  INFORMATION19
  INFORMATION20
  </code></pre>
  
  <p>How to achieve this without being much cpu-intense??
  Thanks in advance!</p>