Allways wanted to spell out numbers ? The most simple solution is using a SQL date (!) format mask:
SQL>select to_char( to_date( 12345, 'J'), 'JSP') Words from dual;
WORDS
----------------------------------------
TWELVE THOUSAND THREE HUNDRED FORTY-FIVE
There is one drawback : it works only with integers between 1 and 5373484..
Comments