Advanced Search

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