How to get the number description [message #87394] |
Sun, 26 December 2004 22:12 |
Abhishek Kakkar
Messages: 8 Registered: November 2004
|
Junior Member |
|
|
Hi all,
I have made a function for displaying the amount in words, it displays the amount into english. I have used the to_date 'JSP' concept for fetching the description of the number into words and it fetches it into ENGLISH and now I want it to be displayed in Russian.
For Example
SQL > SELECT TO_CHAR(TO_DATE('100000','J'),'JSP')
FROM DUAL;
TO_CHAR(TO_DATE('1000
---------------------
ONE HUNDRED THOUSAND
I have installed a new database with Russian settings and trying to work out the same logic but it doesn't work. I get the date and messages in russian but not the value for the date using the same concept. Can anyone pls. help me how I can get the same in russian. If any settings are required pls. help this out. It's really Urgent.
Thanks in Advance
Abhishek
|
|
|
|