Re: Change number to word

From: Roger Stapley <Roger.Stapley_at_Oracle.com>
Date: Wed, 01 Aug 2001 10:46:18 +0000
Message-ID: <3B67DDFA.BB409DB5@Oracle.com>

select TO_CHAR(TO_DATE('1234567', 'J'), 'Jsp') from dual

TO_CHAR(TO_DATE('1234567','J')
One Million Two Hundred Thirty-Four Thousand Five Hundred Sixty-Seven

There is a limit on the number size.
Roger.

Theresa Wong wrote:

> Hi,
>
> Do anyone have soultion about changing number to word (123,456,789 --> One
> hundred million ......) in oracle SQL or PL/SQL.
>
> Regards,
> Theresa
Received on Wed Aug 01 2001 - 05:46:18 CDT