Category: >> Oracle PL/SQL >> Spell out numbers to words Bookmark and Share

<< lastnext >>

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)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 03rd, 2009

SELECT DECODE( SIGN( &num ), -1, 'Negative ', 0, 'Zero', NULL ) ||
       DECODE( SIGN( ABS(&num) ), +1, TO_CHAR( TO_DATE( ABS(&num),'J'),'Jsp') )
FROM dual
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 5