Re: Amounts in figure to be transformed in amounts in letters

From: Sean M. Dillon <sdillon_at_us.oracle.com>
Date: Fri, 21 Jan 2000 07:44:56 -0500
Message-ID: <bFSIOLcdyIpDfu8LuwBowaKpKZq3@4ax.com>

On Fri, 21 Jan 2000 13:08:02 +0100, "Frederic Arslanian" <frederic.arslanian_at_libertysurf.fr> wrote:

From Tom Kyte's IDeveloper Articles page...

( http://govt.oracle.com/~tkyte/Misc/SpellANumber.html )

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

   > /

TO_CHAR(TO_DATE(5373484,'J'),'JSP')

---

Five Million Three Hundred Seventy-Three Thousand Four Hundred Eighty-Four

Not sure how 100 could possible be one THOUSAND, though ;P

>hi!
>
>Can anyone of you tell me if there is an sql command which transforms an
>amounts in figure in an amounts in letters.
>
>i.e 100 gives one thousand
>
>Thanks
>
>fred.
>
>

--
Sean Dillon
Oracle Corporation
sdillon_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jan 21 2000 - 06:44:56 CST