[Oracle] NVL, NVL2 함수

NVL()

nvl(검사할 값, (Null)일 때 값)

NVL2()

nvl(검사할 값, 'NOT Null'일 때 값, (Null)일 때 값)

 

 

---

 

comm 값이 (null) 이면 0으로 출력. (null이 아닐 시, nvl은 본래의 값 출력. nvl2는 1로 출력)

select salary as sal,
    commission_pct as comm,
    nvl(commission_pct,0) as comm_n,
    salary * nvl(commission_pct,1) as s_comm_n,
    nvl2(commission_pct,1,0) as s2_comm_n
from employees;