Home » Developer & Programmer » Forms » conversion
conversion [message #267652] Fri, 14 September 2007 02:07 Go to next message
conversing
Messages: 15
Registered: April 2006
Location: pakistan
Junior Member
can any body help me to convert currency digits into words
for example how can i convert 1000 to one thousand


regards

asif iqbal
Re: conversion [message #267658 is a reply to message #267652] Fri, 14 September 2007 02:20 Go to previous message
Littlefoot
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This might be one way to do that:
SQL> select to_char(to_date(1234, 'j'), 'jsp') num_to_words from dual;

NUM_TO_WORDS
------------------------------------
one thousand two hundred thirty-four
Previous Topic: UNABLE TO RESOLVE THE REFERENCE ITEM
Next Topic: How to use Hierarchical tree in Form 6i
Goto Forum:
  


Current Time: Tue Aug 22 21:34:16 CDT 2017

Total time taken to generate the page: 0.01942 seconds