Returns a replacement value if the expression is NULL.
Syntax
NVL(expr, replacement)Example
Enter values below to update the example in real time.
employee_id→bonus→employees→-- 보너스 없으면 0 처리
SELECT employee_id, NVL(bonus, 0) AS bonus
FROM employees;