Question

Difference between nvl and nvl2 with example

Answer 1

The nvl2 like like combining an nvl with a decode because you can transform a value: NVL ( expr1 , expr2 ): If expr1 is null, then NVL returns expr2. If expr1 is not null, then NVL returns expr1. NVL2 ( expr1 , expr2 , expr3 ): If expr1 is null, thenNVL2 returns expr3.