Monday, October 23, 2017

Difference between NVL and NVL2 function

  1. NVL takes 2 arguments while NVL2 takes 3 arguments.
  2. NVL returns first argument if first argument is not null, NVL2 returns second argument if first argument is not null and returns third argument if first argument is null. 
  3. In case of NVL datatype of return is of First argument, in NVL2 function datatype of return is of Second argument.

No comments:

Post a Comment

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)