Posts tagged tip
Oracle Tip: The decimal marker to a dot, and the thousands marker to a comma in to_number().
02 years ago
by Onno
in Programming
to_number(t.yournumbercolumn,'9G999G999D99','NLS_NUMERIC_CHARACTERS='',.''')
See also:
Oracle NLS_NUMERIC_CHARACTERS
http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_options072.htm