-
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.??
Aniruddha Gupta
-
I haven't heard of it yet within oracle, but if you have
Ms Excel then look there in the help about pivot-tables
Regards
Ben de Boer
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|