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.??
Printable View
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.??
I haven't heard of it yet within oracle, but if you have
Ms Excel then look there in the help about pivot-tables
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