select id, vnum, to_char(wmsys.wm_concat(vname)) c from tab_test group by id,vnum;
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,'[^/]+'))
![](http://hi.csdn.net/attachment/201110/28/0_13197936835jZI.gif)
![](http://hi.csdn.net/attachment/201110/28/0_1319793702001b.gif)
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,'[^/]+'))
![](http://hi.csdn.net/attachment/201110/28/0_13197937232d5T.gif)