有一个字符串拆分的方法[@more@]/* Formatted on 2011/07/12 13:56 (Formatter Plus v4.8.8) */
SELECT SUBSTR ('af,b,cfr,bc', idx1, idx2 - idx1)
FROM (SELECT NVL (LAG (idx) OVER (ORDER BY ROWNUM) + 1, 1) idx1, idx idx2
FROM (SELECT DISTINCT idx
FROM (SELECT DECODE (INSTR ('af,b,cfr,bc',
',',
ROWNUM
),
0, LENGTH ('af,b,cfr,bc') + 1,
INSTR ('af,b,cfr,bc',
',',
ROWNUM
)
) idx
FROM DUAL
CONNECT BY ROWNUM <= LENGTH ('af,b,cfr,bc')
)))
SELECT SUBSTR ('af,b,cfr,bc', idx1, idx2 - idx1)
FROM (SELECT NVL (LAG (idx) OVER (ORDER BY ROWNUM) + 1, 1) idx1, idx idx2
FROM (SELECT DISTINCT idx
FROM (SELECT DECODE (INSTR ('af,b,cfr,bc',
',',
ROWNUM
),
0, LENGTH ('af,b,cfr,bc') + 1,
INSTR ('af,b,cfr,bc',
',',
ROWNUM
)
) idx
FROM DUAL
CONNECT BY ROWNUM <= LENGTH ('af,b,cfr,bc')
)))
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23307206/viewspace-1052739/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
