Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i
ok, thank you
In article <970849685.28683.2.pluto.d4ee154e_at_news.demon.nl>,
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> alter session set nls_numeric_characters = ',.'
> You'll need to however -at least in sqlplus- use to_char with D
(decimal)
> and G (group separator) to get the correct display.
> Of course you can set nls_numeric_characters also in the registry and
in an
> after-logon trigger.
>
> Hth,
>
> Sybran dBakker, Oracle DBA
>
> <erasmo_flores_at_my-deja.com> wrote in message
> news:8ri95i$a4c$1_at_nnrp1.deja.com...
> > Hy, where define the character to use for the separador of
decimals ?
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Oct 07 2000 - 08:33:05 CDT
![]() |
![]() |