Re: NUMBER TO WORDS

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 21 Mar 2000 04:26:55 GMT
Message-ID: <8b6tlv$hji$1@nnrp1.deja.com>

In article <022502e0.fbda2274_at_usw-ex0102-013.remarq.com>, denunez <denunezNOdeSPAM_at_uacj.mx.invalid> wrote:
> I NEED TO KNOW HOW CAN I CHANGE DE LANGUAGE OF THE RESULT OF
> THIS SQL:
> select to_char(to_date(123,'J'),'jsp') from dual RETURNS
> one hundred twenty-three
> I WANT THE RESULT IN ANOTHER LANGUAGE LIKE SPANISH: CIENTO
> VEINTI TRES
> WHAT I NEED TO CHANGE ON THE CLIENT OR ON THE SERVER TANK YOU
>

You have to change NLS_LANGUAGE initialization variable in init.ora file something like spanish (usually american by default). This is how it works in Oracle 7. Don't know about 8 yet. Of course, you have only one language option, you can't change language while system is running.

> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network *
> The fastest and easiest way to search and participate in Usenet -
Free!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 20 2000 - 22:26:55 CST