Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i

Re: Oracle 8i

From: <erasmo_flores_at_my-deja.com>
Date: Sat, 07 Oct 2000 13:33:05 GMT
Message-ID: <8rn8mi$5g9$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US