Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF)
(Move to ...)
Home
▼
Monday, October 23, 2017
Query to Spell a given Number
SELECT DECODE (SIGN ( :N), -1, 'Negative ', 0, 'Zero', NULL)
|| DECODE (SIGN (ABS ( :N)),
+1, TO_CHAR (TO_DATE (ABS ( :N), 'J'), 'Jsp'))
FROM DUAL
/
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment