[mysql/oracle] NULL 처리하기

문제

결과

mysql / oracle

1. case문

SELECT animal_type, (case 
                     when name is null then 'No name' 
                     else name
                     end ) name, sex_upon_intake
from animal_ins
order by animal_id

2. coalesce

SELECT animal_type, coalesce(name, 'No name') name, sex_upon_intake
from animal_ins
order by animal_id

SELECT animal_type, ifnull(name, 'No name') name, sex_upon_intake
from animal_ins
order by animal_id

SELECT animal_type, decode(name, null, 'No name', name) name, sex_upon_intake
from animal_ins
order by animal_id

2. nvl

SELECT animal_type, nvl(name, 'No name') name, sex_upon_intake
from animal_ins
order by animal_id