Number data type in SQL results and Decimal Symbol with "Number fields to_char" option

[vstep]

1) When I turn on "Number fields to_char" option (in Preferences - Window Types - SQL Window of PL/SQL Developer) I have comma (',') as Decimal Symbol in SQL results irrespective of Numbers format (in Tools - Preferences - User Interface - NLS Options - Numbers). How may I set point ('.') as Decimal Symbol in this case?
2) Is it possible some other way (not "Number fields to_char" option) to show a Number data type field e.g. with 20 digits (not in floating point (exponential) format) in SQL results?

 

[Marco Kalter]

The numbers are formatted on the server, so the NLS_LANG or NLS_NUMERIC_CHARACTERS setting of the session controls the decimal separator. You can set it in the Oracle Registry of your Oracle Home or in the Params.ini file in the PL/SQL Developer installation directory.

 

[vstep]

1) I have checked 3 ways to set NLS_NUMERIC_CHARACTERS:
i) command line plsqldev.exe env:nls_numeric_characters= ". " to start PL/SQL Developer;
ii) nls_numeric_characters=". " in params.ini file of PL/SQL Developer;
iii) ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. ' statement.
But in all 3 ways I have comma (',') as Decimal Symbol in SQL results with "Number fields to_char" option.
2) Is it possible some other way (not "Number fields to_char" option) to show a Number data type field e.g. with 20 digits (not in floating point (exponential) format) in SQL results?

 

[Maxmix]

This is strange. At least ALTER SESSION seems to work:

alter session set nls_numeric_characters = '. ';
select 120000000000000000/1.1 from dual;
-- 109090909090909090.9090909090909090909091

alter session set nls_numeric_characters = ', ';
select 120000000000000000/1.1 from dual;
-- 109090909090909090,9090909090909090909091

 

[vstep]

Of course ALTER SESSION is working but the problem is that it seems work not correct with "Number fields to_char" option.

 

[Maxmix]

My example was executed with "Number fields to_char" turned on,
and one can see how the decimal separator changes.