Home » Developer & Programmer » Reports & Discoverer » Convert Numbers into Words
Convert Numbers into Words [message #183658] Fri, 21 July 2006 15:43 Go to next message
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
Senior Member
How we can convert numbers into world e.g. 123 conversion as One Hundred Twenty Three only.
Re: Convert Numbers into Words [message #183660 is a reply to message #183658] Fri, 21 July 2006 15:47 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See http://www.orafaq.com/scripts/plsql/cheqprnt.txt
Re: Convert Numbers into Words [message #183721 is a reply to message #183660] Sat, 22 July 2006 12:15 Go to previous messageGo to next message
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
Senior Member
A lot of thanks.
Re: Convert Numbers into Words [message #183731 is a reply to message #183658] Sat, 22 July 2006 14:53 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
hi

But it has limitation
It can not go beyond 5.5 million value, i think.

Check 5,600,000 .

-Dude

Re: Convert Numbers into Words [message #186934 is a reply to message #183731] Thu, 10 August 2006 03:44 Go to previous message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member

Please check this function

Hope it will help u

samit gandhi
Previous Topic: Regarding oracle reports
Next Topic: Problem in report Scrolling
Goto Forum:
  


Current Time: Wed Dec 07 06:43:33 CST 2016

Total time taken to generate the page: 0.08522 seconds