将字符串转换成TABLE回来函数(oracle)

将字符串转换成TABLE返回函数(oracle)select regexp_substr(A,B,C,D,E,F,G, [^,]+, 1, level)from dua

将字符串转换成TABLE返回函数(oracle)

select regexp_substr('A,B,C,D,E,F,G', '[^,]+', 1, level)  from dualconnect by level <= length(regexp_replace('A,B,C,D,E,F,G', '[^,]*')) + 1;