oracle 中 SPLIT_PART 报错：ORA-00904：”SPLIT_PART“ ：标识符无效，怎么解决？

Question

SELECT SPLIT_PART('aaa,111', ',', 1) AS Part1,
       SPLIT_PART('aaa,111', ',', 2) AS Part2
 from dual;

报错：SPLIT_PART标识符无效，求解

我本来目的是想把下面的WJMC2列 按，拆分成多个行，不要在一行，隔开。请教有什么好方法

Answer 1

试一下这个 splitting-string-into-multiple-rows-in-oracle。

with temp as
         (select 3260481 REQUESTID, '957543,976795' WJMC2
          from dual
          union all
          select 3260484, '1005870,1021425,1041219'
          from dual)
select distinct t.REQUESTID,
                trim(regexp_substr(t.WJMC2, '[^,]+', 1, levels.column_value)) as error
from temp t,
     table (cast(multiset(select level
                          from dual
                          connect by level <= length(regexp_replace(t.WJMC2, '[^,]+')) + 1) as sys.OdciNumberList)) levels