Dear All,
Spell out numbers to words
select decode( sign( &num ), -1, 'Negative ', 0, 'Zero', NULL ) ||
decode( sign( abs(&num) ), +1, to_char( to_date( abs(&num),'J'),'Jsp') )
from dual
Have a pleasant time
Dear All,
Spell out numbers to words
select decode( sign( &num ), -1, 'Negative ', 0, 'Zero', NULL ) ||
decode( sign( abs(&num) ), +1, to_char( to_date( abs(&num),'J'),'Jsp') )
from dual
Have a pleasant time
what about using the following only.
Code:select to_char(to_date(&num,'j')'jsp') from dual