nvl and nvl2 in sql code example

Example: nvl in sql

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