/ Published in: SQL
A few examples of the TO_NUMBER function
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
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;
URL: http://www.databasestar.com/oracle-to_number/