CASE WHEN 조건 THEN 리턴값1 WHEN 조건2 THEN 리턴값2 ELSE 리턴값3 END 예제1) SELECT ENAME, DEPTNO, CASE WHEN DEPTNO='10' THEN 'DESIGN' WHEN DEPTNO='20' THEN 'DEVELOPMENT' ELSE 'MANAGEMENT' END AS DEPT_NAME FROM EMP WHERE JOB='MANAGER'; ENAME DEPTNO DEPT_NAME WH 10 DESIGN SC 30 MANAGEMENT WS 20 DEVELOPMENT