Use NVL to replace a NULL with a designated value SELECT NVL(SALARY, 0) FROM EMPLOYEE Replaces a blank column with zero

Oracle function that will return a non-NULL value if a NULL value is passed to it. Example: SELECT nvl(salary, 'Sorry, no pay!') FROM employees;