Return to Snippet

Revision: 71063
at December 26, 2016 05:10 by bbrumm


Initial Code
SELECT TO_NUMBER('5467.12') FROM DUAL;

SELECT TO_NUMBER('5467.12', '999999.99') FROM DUAL;

SELECT TO_NUMBER('4687841', '9999999') FROM DUAL;

SELECT TO_NUMBER('$65.169', 'L99.999') FROM DUAL;

SELECT TO_NUMBER('123,456,789', '999,999,999') FROM DUAL;

SELECT TO_NUMBER('$17 218,00', 'L999G999D00',' NLS_NUMERIC_CHARACTERS='', ''') FROM DUAL;

Initial URL
http://www.databasestar.com/oracle-to_number/

Initial Description
A few examples of the TO_NUMBER function

Initial Title
Oracle TO_NUMBER Function

Initial Tags
sql, Oracle

Initial Language
SQL