Home » Developer & Programmer » Reports & Discoverer » How to Convert number to words???
How to Convert number to words??? [message #235353] Sat, 05 May 2007 04:52 Go to next message
vijaykumarkona
Messages: 5
Registered: May 2007
Junior Member
hellow ,
how to convert the number to words in oracle . i am working on d2k report .in that suppose i get total value as 1,23,000.58.
so i want this value print in words as :one lach.............like that
so any conversion functions in oracle ??or to write any function or procedure?? please reply me it's urgent

[Updated on: Sat, 05 May 2007 04:53]

Report message to a moderator

Re: How to Convert number to words??? [message #235424 is a reply to message #235353] Sat, 05 May 2007 12:19 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Urgent? You must be kidding! Furthermore, you might check what Tom Kyte suggests.

Basically, you'd use J - JSP trick, such as
SQL> SELECT TO_CHAR(TO_DATE(12300, 'j'), 'jsp') words FROM dual;

WORDS
-----------------------------
twelve thousand three hundred
However, for number notation you use (lakhs etc.), you'll need to write your own function (or modify one of existing ones).
Re: How to Convert number to words??? [message #235455 is a reply to message #235353] Sun, 06 May 2007 04:39 Go to previous message
bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore
Member
Hi,
This will be useful for you.
This utility is for printing Indian amt into Words

Bhupinder Singh
  • Attachment: words.sql
    (Size: 8.38KB, Downloaded 293 times)
Previous Topic: error: SQL-3114: ORA-03114: not connected to ORACLE
Next Topic: Problem with character mode report (merged)
Goto Forum:
  


Current Time: Thu Dec 08 16:17:18 CST 2016

Total time taken to generate the page: 0.13607 seconds