Home » SQL & PL/SQL » SQL & PL/SQL » Convert a Number into Words (Oracle10g Windows XP)
Convert a Number into Words [message #355415] Thu, 23 October 2008 23:56 Go to next message
martis.a@neu.edu
Messages: 1
Registered: October 2008
Location: Boston
Junior Member

I would like to know how to convert a number into words .Is there any function in PL/SQL to convert this .

For eg. $123.06 output is Dollar One Hundred and Twenty Three and 6 cents

Re: Convert a Number into Words [message #355418 is a reply to message #355415] Fri, 24 October 2008 00:03 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You ever heard of this website called Google?
It's very useful for finding answers to basic questions.
Add ORACLE to the title of your post and you'll get a number of valuable hits.
Re: Convert a Number into Words [message #355421 is a reply to message #355415] Fri, 24 October 2008 00:45 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You could also use the "Search" command in menu bar, there are several solutions here.

Regards
Michel
Previous Topic: Execute Immediate for Creating Table
Next Topic: parallel hint to retrive distinct values
Goto Forum:
  


Current Time: Tue Dec 06 04:35:14 CST 2016

Total time taken to generate the page: 0.08745 seconds