在Oracle 11g中，Oracle 又增加了2个查询：pivot（行转列） 和unpivot（列转行）
参考：http://blog.csdn.net/tianlesoftware/article/details/7060306、http://www.oracle.com/technetwork/cn/articles/11g-pivot-101924-zhs.html
google 一下，网上有一篇比较详细的文档：http://www.oracle-developer.net/display.PHP?id=506
pivot 列转行
测试数据 (id，类型名称，销售数量)，案例：根据水果的类型查询出一条数据显示出每种类型的销售数量。
|
1
|
create
table
demo(id
int
,
name
varchar
(20),nums
);
---- 创建表insert into demo values(1,'苹果',1000);insert into demo values(2,2000);insert into demo values(3,4000);insert into demo values(4,'橘子',5000);insert into demo values(5,3000);insert into demo values(6,'葡萄',3500);insert into demo values(7,'芒果',4200);insert into demo values(8,5500);
|
select
name
sql plain" style="white-space:pre-wrap; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,
sum
(nums) nums
from
demo
group
by
name
