select t.id,substr(t.uids,instr(t.uids,',',rownum,rownum)+1,3) from TEST11 t connect by rownum<=3; select t.id,substr(t.uids,instr(t.uids,',',rownum,
阅读背景：
一个sql的应用(加入行,并分解字段)
来源：互联网
select t.id,substr(t.uids,instr(t.uids,',',rownum,rownum)+1,3) from TEST11 t connect by rownum<=3; select t.id,substr(t.uids,instr(t.uids,',',rownum,
分享到：
