numeric format mask group separator
francy77Dec 15 2010 — edited Dec 15 2010Hi,
someone can explain to me why the following quey works well:
SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL
and this one not:
SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL
the only difference is that in the first one there is the G symbol to specify the group separator and in the second one there is a comma (,) to indicate the group separator.
if i run the following:
select * from nls_session_parameters
i find that NLS_NUMERIC_CHARACTERS is ,.
thanks
Francesco