[Oracle DB] DECODE

DECODE

    - 자바의 switch-case와 유사하다.

    - DECODE(column, case, value, ...)

 

SELECT first_name, department_id FROM employees;

SELECT DISTINCT department_id FROM employees;

SELECT * FROM departments;

SELECT
    first_name,
    decode(department_id, 
    90, '익스큐티브',        -- case 90;
    100, '파이낸스',         -- case 100;
    110, '어카운팅',         -- case 110;
    80, '세일즈',            -- case 80;
    '아직 디코드하지 않음')   -- default
    AS 한글부서명
FROM
    employees;