프로그래머스/쿼리

[oracle] IS NULL - NULL 처리하기

have a good time 2025. 3. 25. 15:19

 

 

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

 

NULL 처리 -> NVL 함수