I've function that should change notation of numbers from 12345.67€ to 12345,67€
select
replace(
to_char(round(
123456.789
,2),'999G999G999G990D'||substr('0000000000',1,2),'nls_numeric_characters=''.,'''),'.',','
) || ' €'
from dual;
current result is:
123,456,79 €
the result I want to get:
123456,79 €
But I' dont know how. My oracle returns values in format 123456.79 so this is a reason of my calculation. Doe's anybody know what to do? maybe there is possibility to change returned format of number without convertion in functions? It should be possible but I don't know how to do it