全部博文
-
编辑 删除
Oracle 10g 使用REGEXP_SUBSTR 分拆字符串
SELECT l_count, REGEXP_SUBSTR('add, daddf, dsdf, asdfa, dsfasd, dsfad','[^,]+',1,l_count) AS NAME FROM dual ,(SELECT LEVEL l_count FROM DUAL CONNECT BY LEVEL<=100)W...
