Re: Convert Numbers to Words with SQL

Hi !!!,

check http://www.oracle-dba.com/ora_scr.htm

• Hemant

GHouck wrote:

> A while ago there was a snippet in one of these Oracle
> newsgroups illustrating a way to display numbers as
> full (English) words, using SQL and the Date/Char
> functions.
>
> It created a function that took a number as input,
> listing the words as output; that is:
>
> select f(123.4) from ...
>
> yielded:
>
> 'one hundred twenty three point four'
>
> Does anyone have this example? Or one like it? Or knows
> where it could be located (without having to start from
> scratch, that is)?
>
> Thanks,
>
> Geoff Houck
> systems hk
> hksys_at_teleport.com
> http://www.teleport.com/~hksys
Received on Wed May 27 1998 - 12:10:19 CDT