NVL()

Syntax

NVL(<column_name>, <value to be displayed if value in <column_name> is NULL>)

Example

SELECT NVL(TITLE, 'Sir/Mam') FROM employees;