oracle将一个字段拆分成多个值（regexp_substr函数）详解数据库

例：

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

结果