nvl in oracle code example

Example 1: nvl operator in sql

(NVL) replaces NULL values with same type default
value provided.
For Example = 
Select NVL(commission_percentage, 0)
From Employees;

NVL2( string_to_test, value_if_NOT_null, value_if_null )