SELECT REGEXP_SUBSTR ('11111,22222,33333,44444,', '[^,]+', 1,rownum) as column_val
from dual connect by rownum<=LENGTH ('11111,22222,33333,44444,') - LENGTH (regexp_replace(
Oracle拆分以逗号分隔的字符串,实现类似split的效果
最新推荐文章于 2024-06-25 17:19:55 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)