Oracle Apps Technical Stuff
Thursday, April 11, 2013
Convert Number to Words
SELECT DECODE (SIGN (:p_number), -1, 'Negative ', 0, 'Zero', NULL)
|| DECODE (SIGN (ABS (:p_number)), +1, TO_CHAR ( TO_DATE ( ABS (:p_number), 'J'), 'Jsp'))
FROM DUAL
/
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.