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 Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...