OraFAQ Forum: Forms » change number into words

Home » Developer & Programmer » Forms » change number into words

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

change number into words [message #78772]

Sun, 17 March 2002 19:01

Rajesh Mandawat
Messages: 37
Registered: October 2001

Member

Hi,

How can I change the number into words in report.

Rajesh

Report message to a moderator

Re: change number into words [message #78775 is a reply to message #78772]

Sun, 17 March 2002 23:59

nik
Messages: 55
Registered: January 2002

Member

try this
1* select to_char(to_date(112004,'J'), 'JSP') from dual

TO_CHAR(TO_DATE(112004,'J'),'JSP
--------------------------------
ONE HUNDRED TWELVE THOUSAND FOUR

OR VISIT this address for a more detailed version,

http://www.quest-pipelines.com/Pipelines/PLSQL/archives.htm#code23

Report message to a moderator

Previous Topic:	Re: Connectivity Problem ORA 12154
Next Topic:	Oracle forms 5.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:36:54 CDT 2024