Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Friday, December 16, 2005

Spell out numbers to words

This script will spell out numbers to words (handy for cheque printing)

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: