- NVL takes 2 arguments while NVL2 takes 3 arguments.
- 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.
- In case of NVL datatype of return is of First argument, in NVL2 function datatype of return is of Second argument.
Monday, October 23, 2017
Difference between NVL and NVL2 function
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)
-
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
-
LOT_CONTROL_CODE column contains values as 1 & 2 in mtl_system_items_b table. Inorder to find meaning for this values run below que...
-
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...
No comments:
Post a Comment