title: decimal separator oracle
body: <p>I need to replace comma with point and then i need my value to be a number. 
  So i wrote this:</p>
  
  <pre><code>select replace('12345,6789', ',' , '.') from dual --it works fine
  </code></pre>
  
  <p>but then I want to convert <code>to_number</code> that value and I get the error:</p>
  
  <blockquote>
    <p><code>"invalid number"</code></p>
  </blockquote>