Imagine you have a table as shown below:
----------------------------------------------
EmpName Post City
---------------------------------------------
Ravi Manager Newyark
peter Worker London
Ram Manager Newyark
--------------------------------------------
If you are able to get a report as shown below, then it is Pivot table:
-------------------------------------------------
City Manager Worker
------------------------------------------------
Newyark 2 0
London 0 1
-----------------------------------
That is, values in the rows (such as Manager,worker) have become the FIELD NAMES.
Then it will be called as Pivot Table.
How this can be achieved in oracle sql :
SELECT CITY, SUM(CASE POST WHEN 'Manager' THEN 1 ELSE 0 END) AS 'MANAGER',
SUM(CASE POST WHEN 'Worker' THEN 1 ELSE 0 END) AS 'WORKER'
From EMP
GROUP BY CITY;