有一个字符串拆分的方法[@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博客 ” ,链接:http://blog.itpub.net/23307206/viewspace-1052739/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23307206/viewspace-1052739/