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

문제

내가 작성한 정답 - ORACLE

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

내가 작성한 정답 - MYSQL

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