Home » Developer & Programmer » Forms » How can i convert the numbers into words
How can i convert the numbers into words [message #81403] Thu, 13 February 2003 17:48 Go to next message
Susane
Messages: 27
Registered: September 2002
Junior Member
Hi to all..

I have a problem in converting my record numbers into words. I only used to convert number in whole decimal. My problem is how can i include the centavos in converting the numbers ex. 2535.65 , Can anyone help me. Please your help is highly appreciated.

Codes in number words...

SELECT TO_CHAR ( TO_DATE ( TO_CHAR ( 103465, '99999999999') , 'J'), 'JSP') FROM dual;

returns a value of ONE HUNDRED THREE THOUSAND FOUR HUNDRED SIXTY-FIVE

thanks,

Susane

Report message to a moderator

Re: How can i convert the numbers into words [message #81411 is a reply to message #81403] Fri, 14 February 2003 00:06 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Oracle's Ask Tom website has one answer to this.

Basically, you create a function which accepts a large number, chop that number op and feed the parts to the TO_DATE function.

MHE

Report message to a moderator

Previous Topic: urgent -- changing the look and feel of forms.
Next Topic: multi record block
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 07:10:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.