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 Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...