title: ORACLE - String to number
body: <p>I have a little problem with a column on a table.
  The column is a Varchar named "prize".
  The datas are something like:</p>
  
  <pre><code>00008599
  00004565
  00001600
  etc...
  </code></pre>
  
  <p>They have to become:</p>
  
  <pre><code>85.99
  45.65
  16.00
  etc...
  </code></pre>
  
  <p>I have tried with to_number function but it doesnt work.
  Something like:</p>
  
  <pre><code>SELECT to_number(prize, '999999.99') FROM TABLE
  </code></pre>
  
  <p>The error is: ORA-01722</p>