Re: Decimal delimiter

From: Chmielewski Jacek <jacekch_at_mail.atr.bydgoszcz.pl>
Date: Sun, 10 Dec 2000 14:42:51 -0000
Message-ID: <9101b1$6nj$1@flis.man.torun.pl>

OK, but where can I change it ? How to access it ? Jacek

> Chmielewski Jacek wrote:
>
> > How can I change decimal delimiter ? I still have comma, and I need a
> > point. What to do ? nls_lang ... = " ." cannot work !
> > What can I do ?
> > Jacek
>
> Hi Jacek,
>
> You may use the D delimiter representation in your number format mask
> (e.g. to_char(some_number,99999999D999)) or change a territory part in
> your NLS_LANG parameter. To have a decimal point instead of comma you may,
> for example, set it to value Polish_America.CL8MSWIN1251. This will cause
> a polish messages and decimal point.
>
> Regards Alexander Medvedev
>
Received on Sun Dec 10 2000 - 08:42:51 CST