Snippet Name: NVL Description: Returns a Value if the Expression IS NULL Also see:» IS NOT NULL » Data Types Comment: (none) Language: Highlight Mode: PLSQL Last Modified: March 07th, 2009
Description: Returns a Value if the Expression IS NULL
Also see:» IS NOT NULL » Data Types
SELECT f_name, NVL(middle_name, 'No middle name'), last_name FROM employees WHERE hire_date > SYSDATE - 60; SELECT NVL(bonus, 0) FROM emp_bonuses WHERE last_name = 'Spasky';