Re: Convert Quiz

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 26 Jun 2001 18:12:30 +0200
Message-ID: <tjhcvbbqk9uo96@beta-news.demon.nl>

"libre" <librete_at_kornet.net> wrote in message news:9ha8i9$37f$1_at_imsinews.kornet.net...
> I want to convert number to char(?).
> ex) 123.45 => one hunderd twenty-three ....
>
> sql> select function(123.45) from dual;
> one hunderd twenty-three and 45/100
>
> additionally, this result conver to spanish
>
> plz. help me..
>
>

Check the to_char function in your documentation in the SQL reference manual.

Regards,

Sybrand Bakker, Oracle DBA Received on Tue Jun 26 2001 - 11:12:30 CDT