SELECT substr(PBTYPE, instr(PBTYPE, ',', 1, levels.lvl) + 1, instr(PBTYPE, ',', 1, levels.lvl + 1) -(instr(PBTYPE, ',', 1, levels.lvl) + 1)) as PBTYPE
FROM
(SELECT ',' || PBTYPE || ',' AS PBTYPE,length(PBTYPE) - nvl(length(REPLACE(PBTYPE, ',')), 0) + 1 AS cnt FROM PM_PRODUCT_CHANNEL WHERE PRODUCT_CODE=
(SELECT rownum AS lvl FROM (SELECT MAX(length(PBTYPE || ',') - nvl(length(REPLACE(PBTYPE, ',')), 0)) max_len FROM PM_PRODUCT_CHANNEL) CONNECT BY LEVEL <= max_len) levels
WHERE levels.lvl <= a.cnt
![在这里插入图片描述](https://img-blog.csdnimg.cn/2019092517491791.png)
![在这里插入图片描述](https://img-blog.csdnimg.cn/20190925174924818.png)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)