I have a number stored in data base. I want to change it to words and display it.
I have 100000 stored in data base
and I want to display as One Lakh. Any one please help me.
I know one query.
select to_char(to_date(100000,'j'),'jsp') from dual;
One Hundred Thousand. (But I want it to be displayed as One Lakh)
Up to 5 digit number its giving correct result if it croses its giving in a different way.
If any one tells what to do i would be very much thankful.