SCRIPTS :
Run the following script :
This script will spell out numbers to words (handy for cheque printing). Example '10' --> Ten
select decode( sign( &num ), -1, 'Negative ', 0, 'Zero', NULL ) ||
decode( sign( abs(&num) ), +1, to_char( to_date( abs(&num),'J'),'Jsp') )
from dual
/
Run the following script :
This script will spell out numbers to words (handy for cheque printing). Example '10' --> Ten
select decode( sign( &num ), -1, 'Negative ', 0, 'Zero', NULL ) ||
decode( sign( abs(&num) ), +1, to_char( to_date( abs(&num),'J'),'Jsp') )
from dual
/
No comments:
Post a Comment