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)

Query to get the list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name ,      ttl.formula_type_name ,      ttl.description ,      c.base_context_name from   ff_formula_types_b t ,...