Oracel 经典的语句

1.遍历合并树型结构输出

select id,sys_connect_by_path(name, '>') pname, level as alevel from goodscategory where CONNECT_BY_ISLEAF = 1 start with depth = 1 connect by parentid = prior id

2.unpivot 将列数据转换为行显示

select 需显示的字段,列字段名,列字段值 from 表名 unpivot (列字段值 for列字段名 in (列名1,列名2,列名3.....))

3.pivot 将行数据转换为列显示

select * from 表名 pivot (含有聚合函数的值 for 列名 in ('列名值1','列名值2','列名值3'..))

更多详细参数：

http://blog.csdn.net/lanchengxiaoxiao/article/details/17248027