如下对字符串'10003,1004,1005'进行切割查询
select regexp_substr('10003,1004,1005','[^,]+',1,level) from dual
connect by regexp_substr('10003,1004,1005','[^,]+',1,level) is not null
如下对字符串'10003,1004,1005'进行切割查询
select regexp_substr('10003,1004,1005','[^,]+',1,level) from dual
connect by regexp_substr('10003,1004,1005','[^,]+',1,level) is not null