[资源分享]分享下sql，一行数据按逗号分开转成一列

with t1 as (select 'aa,bbb,sd,asda,ss,saf,123,fwdf'aa from dual)                                    
select regexp_substr((select aa from t1),'[^,]+',1,LEVEL,'i') from dual
connect by level <= length((select aa from t1))-length(regexp_replace((select aa from t1),',',''))+1

图片：微信图片_20230207181849.jpg