字符串转列

iteye_19253

于 2014-10-09 17:43:16 发布

阅读量112

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/iteye_19253/article/details/82606481

版权

oracle 专栏收录该内容

5 篇文章 0 订阅

订阅专栏



SELECT REGEXP_SUBSTR('BSP/B2B/SFS', '[^/]+', 1, rownum) as item
          FROM DUAL
        CONNECT BY ROWNUM <= LENGTH('BSP/B2B/SFS') -
                   LENGTH(REPLACE('BSP/B2B/SFS', '/', '')) + 1)

,BPET,BSP,B2B, 包含 B2B/BSP



  select *
  from (SELECT REGEXP_SUBSTR('BSP/B2B/SFS/', '[^/]+', 1, rownum) as item
          FROM DUAL
        CONNECT BY ROWNUM <= LENGTH('BSP/B2B/SFS/') -LENGTH(REPLACE('BSP/B2B/SFS/', '/', '')) + 1)
  where item not in (
       SELECT nvl(REGEXP_SUBSTR('BPET,BSP,B2B', '[^,]+', 1, rownum),'NULL') FROM DUAL
       CONNECT BY ROWNUM <= LENGTH('BPET,BSP,B2B') -LENGTH(REPLACE('BPET,BSP,B2B', ',', '')) + 1
       )