Home » Developer & Programmer » Forms » How to get the number description
How to get the number description [message #87394] Sun, 26 December 2004 22:12 Go to next message
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
Re: How to get the number description [message #87416 is a reply to message #87394] Fri, 31 December 2004 22:03 Go to previous message
Matloob
Messages: 39
Registered: December 2004
Member
can u forward me the fuction for study
Previous Topic: how to flush the com port
Next Topic: BLOB used to store image in 9i through forms 6i is causing problem
Goto Forum:
  


Current Time: Thu Sep 19 16:37:25 CDT 2024