17,113
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
语句:
SELECT t.ASSET_NO,t.DETECT_TASK_NO,REGEXP_SUBSTR(t.ERROR_CODE, '[^|]+', 1, level) ERROR_CODE from "Spilt_Error" t connect by level <= LENGTH(t.ERROR_CODE) - LENGTH(regexp_replace(t.ERROR_CODE,'|', '')) + 1 order by t.ASSET_NO, t.DETECT_TASK_NO
拆分结果:
将regexp_replace函数替换为replace函数