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
/
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records