converting amount to text

[fhkhan78]

hi dears
i have problem that how can i convert aomount to text?
example
35452
convert to
thirty five thousand foure hundered and fifty two only.

[ramson]

Hi,
Here is an example of converting amount into words.

select sal In_digits,to_ch ar(to_date(sal, 'j'),'jsp') In_Wrds from emp where rownum <= 10;


------but it is having bug, find out what

Ramson