close

/* Formatted on 2012/4/17 下午 04:54:59 (QP5 v5.185.11230.41888) */
WITH test AS (SELECT 'ABC,DEF,GHI,JKL,MNO' str FROM DUAL)

SELECT REGEXP_SUBSTR (str,
'[^,]+',
1,
ROWNUM)
split
FROM test
CONNECT BY LEVEL <= LENGTH (REGEXP_REPLACE (str, '[^,]+')) + 1

arrow
arrow
    全站熱搜

    nillwu 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄