Case문과 Decode문의 비교

-- CASE

if(when)와 then이 포함된 조건문

 

예시)

select last_name, job_id, salary,

case job_id

when 'IT_PROG' then 1.1 * salary

when 'ST_CLERK' then 1.15 * salary

when 'SA_REP' then 1.2 * salary

else salary end as bonus_sal

from employees;

 

-- decode

if와 then이 포함되지 않은 조건문

 

예시)

select last_name, job_id, salary,

decode(job_id

,'IT_PROG' , 1.1 * salary

,'ST_CLERK', 1.15 * salary

,'SA_REP' , 1.2 * salary

,salary) as bonus_sal

from employees;