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

APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records