[IS NULL/LEVEL2] NULL 처리하기 (MySQL /Oracle)

MySQL

SELECT    ANIMAL_TYPE
        , IFNULL(NAME, 'No name') AS 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;