nvl

Description Syntax Parameters Returns Example
Substitues values when NULL values encountered. nvl(expr1, expr2) expr1: expression 1.
expr2: expression 2. If expression1 is null, returns expression2; otherwise returns expression1. nvl(expression1, expression2)

nvl(expression1, 'expression2')