Oracle数据库case的作用，查询很管用的

 

select e.empno
       ,e.ename
       ,case
          when e.deptno = 10 then '壹拾'
          when e.deptno = 20 then '贰拾'
          when e.deptno = 30 then '叁拾'
          else '无'
        end as chineseDeptNO
from emp e