Re: NLS

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Mon, 13 Nov 2000 02:23:40 +0000
Message-ID: <8uo4tm$3io$1@bob.news.rcn.net>

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.

I suspect that your problem has to do with formatting rather than NLS. Try the SQL*Plus command:

SET NUMWIDTH

-- 
Once I learned how to spell DBA I became one

Received on Sun Nov 12 2000 - 20:23:40 CST