Re: Decimal delimiter

NLS_LANG needs to be set as env var (Unix) or in hklm\software\oracle (Wintel) *on the client*

Regards,

Sybrand Bakker, Oracle DBA

"Chmielewski Jacek" <jacekch_at_mail.atr.bydgoszcz.pl> wrote in message news:9101b1$6nj$1_at_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 - 10:35:47 CST