Howdy, Stranger!

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

Categories

Want to display a number in words

priya_sankapriya_sanka Member Posts: 15
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.