nvl (Short Description to be added). 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') Copyright © Cloud Software Group, Inc. All Rights Reserved.