Snippet Name: Spell out numbers to words Description: This handy little script will spell out numbers to words. For example, "123" will become "one two three". Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 03rd, 2009
Description: This handy little script will spell out numbers to words. For example, "123" will become "one two three".
SELECT DECODE( SIGN( &num ), -1, 'Negative ', 0, 'Zero', NULL ) || DECODE( SIGN( ABS(&num) ), +1, TO_CHAR( TO_DATE( ABS(&num),'J'),'Jsp') ) FROM dual