Re: NUMBER TO WORDS

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 21 Mar 2000 04:37:55 GMT
Message-ID: <8b6ub1$i1f$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
>

Sorry, my first message wasn't complete. On the client side, you can change session parameters with SQL statement:

alter session set NLS_LANGUAGE=spanish (check correct language name in the NLS documentation).

> * 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:37:55 CST