Want to display a number in words

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.


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!