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)

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)