Posted By

bbrumm on 12/26/16

Tagged

sql
Oracle

Versions (?)

Last Edited at 12/26/16 05:10am

Statistics

Viewed 875 times

Favorited by 0 user(s)

Related snippets

Oracle TO_NUMBER Function

/ 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;