Dears,
First thank you upfront for considering and maybe answering this post.
We create reports using APEX and need to present numbers formated with "," as decimal separator and " " as thousand separator. Ex : "1000000.001" becomes "1 000 000,001"
The solution we currently use is to format every column of our reports from within the query :
select to_char(value_to_display,'999G999G999G999D9999999','nls_numeric_characters='', ''') value_to_display,
...
from ...
;
This works, but is not neat as it can't be changed easily all at once, it requires us to do this for every single column we need to format.
We would like to set a different the nls_numeric_characters at the session level, if possible, and override the default NLS configuration, which seems to be drawn from the browser settings as activating debug shows me :
Language derived from: FLOW_PRIMARY_LANGUAGE, current browser language: en
alter session set nls_language='AMERICAN' nls_territory='AMERICA'
Would anyone know of a neat solution to force the 'nls_numeric_characters' accross the session ?
Thank you in advance,
David A.