OraFAQ Forum: Reports & Discoverer » How to Convert number to words???

Home » Developer & Programmer » Reports & Discoverer » How to Convert number to words???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Convert number to words??? [message #235353]

Sat, 05 May 2007 04:52

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: How to Convert number to words??? [message #235455 is a reply to message #235353]

Sun, 06 May 2007 04:39

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 1356 times)

Report message to a moderator

Previous Topic:	error: SQL-3114: ORA-03114: not connected to ORACLE
Next Topic:	Problem with character mode report (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 17:44:23 CST 2024