select regexp_substr('123,456,789','[^,]+') from dual --123
select regexp_substr('123,456,789','[^,]+',1,2) from dual --456
select regexp_substr('123,456,789','[^,]+',1,3) from dual --789
select regexp_substr('123,456,789','[^,]+',2,1) from dual --23
select regexp_substr('123,456,789','[^,]+',2,2) from dual --456
select regexp_substr('123,456,789','[^,]+',2,3) from dual --789
select regexp_substr('123,456,789','[^,]+',3,3) from dual --789 |
立即参与
