oracle以空格为分隔,Oracle-分割字符串逗号分隔(字符串包含空格和连续逗号)

我找不到有关如何在ORACLE中拆分逗号分隔字符串的解决方案.搜索了很多,没有什么适用于我的情况

码

DECLARE

TYPE T_ARRAY_OF_VARCHAR IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

MY_ARRAY T_ARRAY_OF_VARCHAR;

MY_STRING VARCHAR2(2000) := '12 3,456,,abc,def';

BEGIN

FOR CURRENT_ROW IN (

with test as

(select MY_STRING from dual)

select regexp_substr(MY_STRING, '[^,]+', 1, rownum) SPLIT

from test

connect by level <= length (regexp_replace(MY_STRING, '[^,]+')) + 1)

LOOP

DBMS_OUTPUT.PUT_LINE('>' || CURRENT_ROW.SPLIT || '

--DBMS_OUTPUT.PUT_LINE(CURRENT_ROW.SPLIT);

MY_ARRAY(MY_ARRAY.COUNT) := CURRENT_ROW.SPLIT;

END LOOP;

DBMS_OUTPUT.PUT_LINE('Array Size:' || MY_ARRAY.COUNT);

END;

/

输出是:

>12 3<

>456<

>abc<

>def<

><

Array Size:5

空值无序!!!!