꿈라CBT다음 SQL과 결과가 다른 SQL은 무엇인가?
보기
SELECT ENAME, CASE WHEN SAL IS NULL THEN 100 ELSE SAL END AS RESULT FROM EMP;
- 1SELECT ENAME, NVL(SAL, 100) AS RESULT FROM EMP;
- 2SELECT ENAME, COALESCE(SAL, 100) AS RESULT FROM EMP;
- 3SELECT ENAME, DECODE(SAL, NULL, 100, SAL) AS RESULT FROM EMP;
- 4SELECT ENAME, NVL2(SAL, 100, SAL) AS RESULT FROM EMP;