将字符串转换成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; 