example of a pivot table

select job,
count(decode(deptno,10,'Deptno 10')) "Deptno 10"
,count(decode(deptno,20,'Deptno 20')) "Deptno 20",
count(decode(deptno,30,'Deptno 30')) "Deptno 30"
from emp
group by job