3,491
社区成员
发帖
与我相关
我的任务
分享
select ids, id from(
select regexp_substr(ids, '[^,]+',1,lvl) ids, lvl, id from t,
(select level lvl from dual connect by
level < =(select max(length(regexp_replace(ids,'[^,]','')))+1 max_tokens from t))
) where ids is not null order by id, lvl;