SELECT DEPT_NO,
  CASE DEPT_NO
    WHEN '01' THEN 'HR'
    WHEN '02' THEN 'IT'
    WHEN '04' THEN 'Sales'
    ELSE 'etc'
  END AS DEPT_NAME
FROM DEPT;