JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page. 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') Copyright © Cloud Software Group, Inc. All rights reserved.