select nvl code example

Example: nvl operator in sql

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