코딩테스트/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