SQLD · 60회 변형 · 어려움 난이도 · 42번

Question

다음 SELECT 문 중 실행 결과가 NULL인 것은?

Accepted Answer

SELECT NULLIF(20, 20) + 1 FROM DUAL;

Answer

SELECT COALESCE(NULL, NULL, 5) * 2 FROM DUAL;

Answer

SELECT NVL(NULL, 3) * NVL(NULL, 4) FROM DUAL;

Answer

SELECT NVL(NULL, 0) + 10 FROM DUAL;