- 博客(1)
- 资源 (1)
- 问答 (3)
- 收藏
- 关注
原创 oracle11g行列转换
列转行select * from t;1 1 a2 2 b3 3 c4 3 dselect id,listagg(name,',') within group(order by name) from t group by id;1 1 a2 2 b3 3 c,d行转列with a as (select '
2015-09-18 16:49:50 917
TA创建的收藏夹 TA关注的收藏夹
TA关注的人
列转行select * from t;1 1 a2 2 b3 3 c4 3 dselect id,listagg(name,',') within group(order by name) from t group by id;1 1 a2 2 b3 3 c,d行转列with a as (select '
2015-09-18 16:49:50 917
TA创建的收藏夹 TA关注的收藏夹
TA关注的人