Home » SQL & PL/SQL » SQL & PL/SQL » Need to convert amount in numbers into words
Need to convert amount in numbers into words [message #287419] Wed, 12 December 2007 03:46 Go to next message
bholaimmu
Messages: 35
Registered: October 2007
Member
Hi All,

Does anyone have the package which converts amount in numbers ( 100 ) into words ( one houndred )And which can also converts lacs n crores amount ( 2,50000 ) also in words ( two lakhs and fifty thoudand ) ?


Thx N Regs,
BholaImmu.
Re: Need to convert amount in numbers into words [message #287423 is a reply to message #287419] Wed, 12 December 2007 03:49 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Asktom: Spell the number

Modify to your needs. I haven't got an idea about laks, crores,...

MHE

[Updated on: Wed, 12 December 2007 03:51]

Report message to a moderator

Re: Need to convert amount in numbers into words [message #287424 is a reply to message #287423] Wed, 12 December 2007 03:54 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

thats really gud link from MEHE
Re: Need to convert amount in numbers into words [message #287433 is a reply to message #287423] Wed, 12 December 2007 04:19 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Maaher wrote on Wed, 12 December 2007 10:49

Asktom: Spell the number

Modify to your needs. I haven't got an idea about laks, crores,...

MHE

If I recall correctly, Barbara adjusted the code given in that thread to work with crores and lakhs.
Re: Need to convert amount in numbers into words [message #287435 is a reply to message #287424] Wed, 12 December 2007 04:24 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
musman wrote on Wed, 12 December 2007 10:54

thats really gud link from MEHE

That's also amazing ... 3 words of 6 aren't correctly written.
Re: Need to convert amount in numbers into words [message #287439 is a reply to message #287419] Wed, 12 December 2007 04:26 Go to previous messageGo to next message
bholaimmu
Messages: 35
Registered: October 2007
Member
Thx a lot.. I am going through TOM solution and trying to modify as per Indian Standards.

Thx N Regs,
BholaImmu.
Re: Need to convert amount in numbers into words [message #287441 is a reply to message #287439] Wed, 12 December 2007 04:29 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Frank is right! It has been a long time since I read that thread and I knew that there were some variants, but apparently the Indian variant is there too.

MHE
Re: Need to convert amount in numbers into words [message #287575 is a reply to message #287441] Wed, 12 December 2007 13:12 Go to previous message
Barbara Boehmer
Messages: 8635
Registered: November 2002
Location: California, USA
Senior Member
If you scroll down on that page, you will find the Indian version. Here is a direct link to that point:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1407603857650#4232815086519
Previous Topic: Needs Help about Query
Next Topic: geting specified data from a text file using utl_fie
Goto Forum:
  


Current Time: Wed Dec 07 18:15:04 CST 2016

Total time taken to generate the page: 0.09149 seconds