Saturday, 4 July 2015

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
/




No comments:

Post a Comment