NVL2()

Description of nvl2.eps follows

Syntax.

NVL2( string1, value_if_not_null, value_if_null )

  • The Oracle/PLSQL NVL2 function extends the functionality found in the NVL function
  • NVL2 lets you determine the value returned by a query based on whether a specified expression is null or not null. If expr1 is not null, then NVL2 returns expr2. If expr1 is null, then NVL2 returns expr3.
  • The argument expr1 can have any data type. The arguments expr2 and expr3 can have any data types except LONG.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top