NVL Function

NVL Function
In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is encountered.
http://www.techonthenet.com/oracle/functions/nvl.php