nvl operator in sql
snippet in sql

nvl operator in sql

user6286

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