Home » SQL & PL/SQL » SQL & PL/SQL » figure to words (Oracle 9i-9.2.0.1.0 [Enterprise Edition])
figure to words [message #375860] Mon, 15 December 2008 03:22 Go to next message
jimit_shaili
Messages: 231
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Friends

I required number to words function for world currency.

Example: if my number is 30949.20

i required in words like this,

"US DOLLARS THIRTY THOUSAND NINE HUNDRED FORTY NINE & CENT TWENTY ONLY"

so please provide me pl/sql function.
is it possible through query?suggest me.


Regards

Jimit


Re: figure to words [message #375862 is a reply to message #375860] Mon, 15 December 2008 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for "spell numbers"

Regards
Michel
Re: figure to words [message #375863 is a reply to message #375860] Mon, 15 December 2008 03:25 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
lots of solutions already offerin this forum itself. you shall search and can find out. Barbara had written function itself on some message board.
yours
dr.s.raghuanthan
Previous Topic: Update multiple rows in a column
Next Topic: checking value of %rowtype
Goto Forum:
  


Current Time: Fri Dec 09 19:32:38 CST 2016

Total time taken to generate the page: 0.10572 seconds