Re: Spelling out numbers

From: <mhr123_at_my-deja.com>
Date: Tue, 23 Jan 2001 08:40:52 GMT
Message-ID: <94jg2j$ba5$1@nnrp1.deja.com>

Hi,

Take a look at this example from Tom Kyte:

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

Regards, Michael Ringbo

In article <94j36j$13t$1_at_nnrp1.deja.com>, freejakr_at_my-deja.com wrote:
> Could anyone tell me a technique for having an
> Oracle number column presented as a spelled out
> value?
>
> What I'd like to get from this data:
>
> ENAME "Fred" SAL 1465
>
> is:
>
> ENAME SAL
> Fred One thousand four hundred sixty five
>
> Thanks for any leads.
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 23 2001 - 02:40:52 CST