title: Convert string to decimal Oracle database
body: <p>I intended convert data type string to decimal  in Oracle data base and i get this error:</p>
  
  <blockquote>
    <p>ORA-01722: número no válido 01722. 00000 - "invalid number" *Cause:
    The specified number was invalid. *Action: Specify a valid number</p>
  </blockquote>
  
  <p>Code: </p>
  
  <pre><code>TO_NUMBER('5.0') AS numero
  
  CAST('5.0' AS NUMBER) AS numero
  </code></pre>