将字符串转换成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; 发布时间: 2012-09-17 12:06:51 作者: rapoo
将字符串转换成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;