试一下这个 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))...
试一下这个 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))...