oracle 行转列例子代码

select * from (select deptno,job,sal from emp)
pivot(
       sum(sal)
       for job in (
         'ANALYST' as analyst_sal,
         'MANAGER' as manager_sal,
         'CLERK' as clerk_sal,
         'SALESMAN' as salesman_sal,
         'PRESIDENT' as president_sal
         )
)
order by deptno;