例:
select regexp_substr(p.attributename, '[^,]+',1,level) c1
from tablename p
connect by level <= length(p.attributename) - length(replace(p.attributename,',','')) + 1
结果
例:
select regexp_substr(p.attributename, '[^,]+',1,level) c1
from tablename p
connect by level <= length(p.attributename) - length(replace(p.attributename,',','')) + 1