spelling a number-how does it work?

From: Anurag <anurag_at_synergy-infotech.com>
Date: Sat, 27 Nov 1999 22:37:43 -0800
Message-ID: <11f733ec.87992092@usw-ex0101-007.remarq.com>

Hi,
I came upon the following script a Thomas Kyte's web site on Oracle.

How To 'spell' a number

The question arises -- how can I get "ten" back from the number 10? How can I spell numbers out?

You can use a date function to do this....

       1* select to_char( to_date(5373484,'J'),'Jsp') from dual
     SQL> /

     TO_CHAR(TO_DATE(5373484,'J'),'JSP')
    
--------------------------------------------------------------------------
     Five Million Three Hundred Seventy-Three Thousand Four Hundred

Eighty-Four

This will work for numbers between 1 and 5,373,484...

I tried it , it works but how?

Thanks
Anurag

also reply at
anurag_at_synergy-infotech.com

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

Received on Sun Nov 28 1999 - 00:37:43 CST