Spell number to words
Posted by
www.2012updates.com
Labels:
PL/SQL
select
decode( sign( &num ), -1, 'Negative ', 0, 'Zero', NULL ) decode( sign( abs(&num) ), +1, to_char( to_date( abs(&num),'J'),'Jsp') )
from dual
/
Subscribe to:
Post Comments (Atom)
March 19, 2008 1:54 PM
Using JSP this way has a number of limitations. FFSP would be a better way to go. See SQL Snippets: Transformations - Numbers to Words.
Post a Comment