Re: Spelling out numbers

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 23 Jan 2001 06:26:45 +0100
Message-ID: <t6rpf0clqo1m2e@beta-news.demon.nl>

There is a to_char option for this, IIRC it is simply to_char(<column>, 'sp') Please Check out the Oracle sql reference manual to confirm this.

Hth,

Sybrand Bakker, Oracle DBA

<freejakr_at_my-deja.com> wrote in message news:94j36j$13t$1_at_nnrp1.deja.com...
> 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/
Received on Mon Jan 22 2001 - 23:26:45 CST