11 2013 档案

oracle 将逗号分隔的字符串转成多行记录
摘要：select regexp_substr('a,b,c,d', '[^,]+', 1, rownum), length('a,b,c,d') - length(replace('a,b,c,d', ',', '')) + 1, rownum, length(replace('a,b,c,d', ',', '')), length('a,b,c,d') from dualconnect by rownum <= length( 阅读全文
posted @ 2013-11-08 09:29 cczz_11 阅读(5284) 评论(0) 推荐(0) 编辑