Re: NLS_NUMERIC_CHARACTERS

> I run my forms with NLS_LANG=FRENCH_FRANCE.WE8ISO8859P1
> I try to change the decimal symbol "," for "." with the command
> "alter session set NLS_NUMERIC_CHARACTERS='.,';"
> and it does not work.
> What should i do ?
>
> thanks in advance

I used the following a few days ago:

select to_number('1234.56', '9999D99', ' NLS_NUMERIC_CHARACTERS = ''.,'' ') from dual;

and it worked great. In the format-String '9999D99' the letter 'D' stands for the decimal-sign. The
letter 'G' would stand for the group-character.

Hope this will help you. Let me know, please.

Regards, Stephan

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------