将字符串oracle拆分为单个列并插入表中

WITH data AS (  SELECt 'test.doc#delimiter#1234,test1.doc#delimiter#1235,test2.doc#delimiter#1236' AS "value" FROM DUAL  UNIOn ALL  SELECt 'fil1.txt#delimiter#1456,fil1.txt#delimiter#1457' AS "value" FROM DUAL)SELECt  REGEXP_SUBSTr( data."value", '[^,]+', 1, levels.COLUMN_VALUE )FROM    data,        TABLE(          CAST( MULTISET(   SELECt LEVEL   FROM   DUAL   ConNECT BY  LEVEL <= LENGTH( regexp_replace( "value", '[^,]+'))  + 1 ) AS sys.OdciNumberList          )        ) levels;