参考下面的两个SQL
select regexp_substr('aa,bb,cc,dd', '[^,]+', 1, level)
from dual
connect by regexp_substr('aa,bb,cc,dd', '[^,]+', 1, level) is not null
;
with csv as
(select 'aa,bb,cc,dd' AS csvdata from DUAL)
select regexp_substr(csv.csvdata, '[^,]+', 1, level) as pivot_char
from dual, csv
Connect by regexp_substr(csv.csvdata, '[^,]+', 1, level) is not null
;