Application Express

SELECT * FROM (
SELECT WORK_COUNTRY as country, 
            JOB 
FROM WWV_DEMO_EMP )
PIVOT                                          
(COUNT(*) FOR JOB IN (
  'President' as President,
  'Manager' as Manager,
  'Analyst' as Analyst,
  'Salesman' as Salesman,
  'Clerk' as Clerk)
)