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

currentAppUi built in variable in VBCS

$global.currentAppUi.id :- The id of the App UI $global.currentAppUi.urlId :-The id of the App UI as shown in the URL $global.currentAppUi.d...