Returns different values depending on whether the expression is NULL.
Syntax
NVL2(expr, v_notnull, v_null)Example
Enter values below to update the example in real time.
employee_id→bonus→bonus_yn→employees→SELECT employee_id,
NVL2(bonus, '보너스 있음', '보너스 없음') AS bonus_yn
FROM employees;