Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Decimal delimiter
Try this.
Put this line in init<SID>.ora file
NLS_NUMERIC_CHARACTERS= ".,"
Don't forget quotation marks
-- ---------------------------------------------------------------------------- -------------------------------- Ermin Dzinic dip.ing Tel: + 387 71 206 763 projektant-programer 206 764 digiNET d.o.o. Fax: + 387 71 444 339 71000 Sarajevo BiH ---------------------------------------------------------------------------- ---------------------------------- Johannes Wilhelm <x15_at_aixterm8.urz.uni-heidelberg.de> wrote in message news:90q7hj$qe$1_at_news.urz.uni-heidelberg.de...Received on Tue Dec 12 2000 - 08:29:32 CST
> Chmielewski Jacek <jacekch_at_mail.atr.bydgoszcz.pl> 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
>
> Try NLS_NUMERIC_CHARACTERS=.,
>
> Johanne