NULL 처리하기

 

 

SELECT ANIMAL_TYPE,
(CASE WHEN NAME IS NULL THEN 'No name' ELSE NAME END) AS NAME,
SEX_UPON_INTAKE
FROM ANIMAL_INS

CASE 문 끝에는 꼭 END를 넣어줄 것...!