Nvl

Description: Returns a Value if the Expression IS NULL

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';

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.