Programmers/SQL
[mysql/oracle] NULL 처리하기
Anoi
2023. 1. 27. 00:38
문제

결과

mysql / oracle
1. case문
1
2
3
4
5
6
|
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
|
cs |
2. coalesce
1
2
3
|
SELECT animal_type, coalesce(name, 'No name') name, sex_upon_intake
from animal_ins
order by animal_id
|
cs |
mysql
1. ifnull
1
2
3
|
SELECT animal_type, ifnull(name, 'No name') name, sex_upon_intake
from animal_ins
order by animal_id
|
cs |
oracle
1. decode
1
2
3
|
SELECT animal_type, decode(name, null, 'No name', name) name, sex_upon_intake
from animal_ins
order by animal_id
|
cs |
2. nvl
1
2
3
|
SELECT animal_type, nvl(name, 'No name') name, sex_upon_intake
from animal_ins
order by animal_id
|
cs |