PIVOT TABLE

[ag_201074]

this may sound very simple..............
i came across the PIVOT Table can anybody tell what exactly is ths table its structure and what exactly is it used for.??

[bensr]

I haven't heard of it yet within oracle, but if you have
Ms Excel then look there in the help about pivot-tables

[miritika]

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