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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 22 Jan 2000 09:26:48 -0500
Message-ID: <1hfj8sguphgqulrab5tk7p67pb0f4nuh67@4ax.com>

A copy of this was sent to "Frederic Arslanian" <frederic.arslanian_at_libertysurf.fr>
(if that email address didn't require changing) On Fri, 21 Jan 2000 13:07:09 +0100, you wrote:

>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.
>

see http://osi.oracle.com/~tkyte/Misc/SpellANumber.html

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Jan 22 2000 - 08:26:48 CST