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

Home -> Community -> Usenet -> c.d.o.tools -> Re: NLS

Re: NLS

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Mon, 13 Nov 2000 04:49:14 GMT
Message-ID: <8unrs9$2e3$1@nnrp1.deja.com>

In article <8unkj1$snf$1_at_nnrp1.deja.com>,   eastking_at_my-deja.com wrote:
> Hello, every one here.
>
> I executed following script in winNT, Oracle 8i. It
> returned '############',I did not know what happened.
>
> select to_char(1234124231.344,'L9G999D99','NLS_CURRENCY="Dfl"') from
> dual
>
> Thank you in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Isn't format mask a little bit short for your number? Looks like that.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Nov 12 2000 - 22:49:14 CST

Original text of this message

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