[Oracle] decode()

DECODE()

decode( 컬럼명, 조건1, 값1, 조건2, 값2, 그 외값)

 

 

---

 

EX1

-- 문제. hr.employees 활용하기
-- 1) 30번과 50번 부서 소속 직원에서 금여 10% 인상

select first_name,
    DEPARTMENT_ID,
    SALARY,
    decode(DEPARTMENT_ID,30,SALARY*1.1,50,SALARY*1.1,0) as increased_pay,
    decode(DEPARTMENT_ID,30,'10%+',50,'10%+','--') as stat
from employees;

 

 

EX2

-- 2)인상된 직원 set 만 출력

select first_name,
    DEPARTMENT_ID,
    SALARY,
    decode(DEPARTMENT_ID,30,SALARY*1.1,50,SALARY*1.1,SALARY) as increased_pay,
    decode(DEPARTMENT_ID,30,'10%+',50,'10%+','--') as stat
from employees
where department_id in (30,50);