[SQL문제풀기] NULL 처리하기

문제

MYSQL

내가 작성한 정답

SELECT ANIMAL_TYPE, IFNULL(NAME,'No name'), SEX_UPON_INTAKE
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;

ORACLE

내가 작성한 정답

SELECT ANIMAL_TYPE, NVL(NAME,'No name'), SEX_UPON_INTAKE
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;