| Conversion of Currency in to words [message #283466] |
Tue, 27 November 2007 04:43  |
venkatadeekshi
Messages: 17
Registered: October 2007
|
Junior Member |
|
|
Hi,
I am developing an invoice report based on the tables ra_customer_trx_all and ra_customer_trx_lines_all. I want to display the total invoice amount in words based on the currency code in a formula column
The currency_code column in ra_customer_trx_lines_all is having data as USD,GBP,INR etc.
suppose the invoice amount is 10000 and the currency_code is USD.
Then the amount should be displayed as US DOLLARS TEN THOUSAND ONLY
If the Currency code is INR then the amount should be displayed as RUPEES TEN THOUSAND ONLY
Please suggest me a solution
Thanks & Regards
|
|
|
|
| Re: Conversion of Currency in to words [message #283473 is a reply to message #283466] |
Tue, 27 November 2007 05:07  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
This is the way to do it:SQL> select to_char(to_date(1234, 'j'), 'jsp') num_to_words from dual;
NUM_TO_WORDS
------------------------------------
one thousand two hundred thirty-four
SQL>
You'll have to concatenate 'USD', 'RUPEES' etc. by yourself, depending on currency name.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
