[oracle] IS NULL - NULL 처리하기

 

 

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

 

NULL 처리 -> NVL 함수