Skip to main content

Categories: Conditional

NVL

Returns the value of the first expression, if it is not NULL. Otherwise, returns the value of the second expression.

Syntax​

NVL(expression1, expression2) → same as input type​

  • expression1: The expression can be any data type, however, both expressions contained in the argument must be of the same type.
  • expression2: The expression can be any data type, however, both expressions contained in the argument must be of the same type.

Examples

NVL example 
SELECT NVL(NULL, 2)
-- 2
NVL example 
SELECT NVL(5, 2)
-- 5