实现方式类似，select id,regexp_substr(name1,'[^,]+',1,level) data
from test123
connect by prior id=id and level<=regexp_count(name1,',')+1 and prior dbms_random.value is not null;具体参考下方链接

https://eco.dameng.com/community/article/ea2b08d10963fdb4b9f77d25021dc2fa

--示例
drop table cs1_0;
create table cs1_0 (slid int ,bs varchar);

insert into cs1_0 values (2024,'1,2,3,48');commit;
select bs from cs1_0 where slid='2024';

select regexp_substr((select bs from cs1_0 where slid='2024'),'[^,]+',1,LEVEL,'i') as 分割后结果 from dual
connect by level <= length((select bs from cs1_0 where slid='2024'))-length(regexp_replace((select bs from cs1_0 where slid='2024'),',',''))+1;