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

Query to get the list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name ,      ttl.formula_type_name ,      ttl.description ,      c.base_context_name from   ff_formula_types_b t ,...