Re: NUMBER TO WORDS

denunez wrote in message <11c3f80c.f17e295b_at_usw-ex0102-013.remarq.com>...
>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:
Neat idea, but I don't think it's possible using standard Oracle functions.

You'd have thought adding the NLS format would do it ....

select to_char(to_date(123,'J'),'jsp','NLS_DATE_LANGUAGE=SPANISH')

       from dual;

but the manual (Oracle7 Server SQL Reference) says:

    "When you add one of these suffixes (SP) to a date format element,      the return value is always in English."

Don't know about Oracle8.

It wouldn't be too hard to write your own function to convert numbers to words using PL/SQL. It's the only thing I can think of.

Dave.

--
There's no need to reply to this posting by email, but if you do,
remove the "nospam" from my email address first.