有一个表，表名为tab_test，如下：
一、多行转一列
select id, vnum, to_char(wmsys.wm_concat(vname)) c
from tab_test group by id,vnum;
执行上述sql后，如下：
二、一列转多行
with a as (select '/ABC/AA/AD/ABD/JI/CC/ALSKD/ALDKDJ' id from dual)
select regexp_substr(id,'[^/]+',1,rownum) id from a
connect by rownum <= length(regexp_replace(id,'[^/]+'))
执行上述sql后如下：
一、多行转一列
select id, vnum, to_char(wmsys.wm_concat(vname)) c
from tab_test group by id,vnum;
执行上述sql后，如下：
二、一列转多行
with a as (select '/ABC/AA/AD/ABD/JI/CC/ALSKD/ALDKDJ' id from dual)
select regexp_substr(id,'[^/]+',1,rownum) id from a
connect by rownum <= length(regexp_replace(id,'[^/]+'))
执行上述sql后如下：
转载自：http://blog.163.com/fushahui_1988@126/blog/static/82879994201192844355174/
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
