Home » Developer & Programmer » Forms » change number into words
change number into words [message #78772] Sun, 17 March 2002 19:01 Go to next message
Rajesh Mandawat
Messages: 37
Registered: October 2001
Member
Hi,

How can I change the number into words in report.

Rajesh
Re: change number into words [message #78775 is a reply to message #78772] Sun, 17 March 2002 23:59 Go to previous message
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
Previous Topic: Re: Connectivity Problem ORA 12154
Next Topic: Oracle forms 5.0
Goto Forum:
  


Current Time: Sun May 24 17:36:38 CDT 2020