[프로그래머스] NULL 처리하기

SELECT ANIMAL_TYPE, IFNULL(NAME,'No name') AS NAME, SEX_UPON_INTAKE
FROM ANIMAL_INS;

• MySQL
• IFNULL (A,B) : A가 NULL이면 B를, NULL이 아니면 A 반환

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

• Oracle