nvl in sql
snippet in sql

nvl in sql

user1032

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