Try this: Number to Words Conversion

Dear All,

[B][COLOR="DarkGreen"]Spell out numbers to words[/COLOR][/B]

[COLOR="DimGray"][B]select decode( sign( &num ), -1, 'Negative ', 0, 'Zero', NULL ) ||
decode( sign( abs(&num) ), +1, to_char( to_date( abs(&num),'J'),'Jsp') )
from dual[/B][/COLOR]

Have a pleasant time

:)

what about using the following only.
[code]select to_char(to_date(&num,'j')'jsp') from dual[/code]