Want to display a number in words

Hi,
I have a number stored in data base. I want to change it to words and display it.

Ex:
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;

Output:
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.

Regards
Priya

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories