日期:2014-05-16 浏览次数:20755 次
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;