코딩테스트/Oracle

[Level 2] NULL 처리하기

eunki 2021. 7. 29. 18:26
728x90

[문제]

 

 

 

[코드]

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