한줄을 여러줄로 표현 하기 구분자값 '/'

with t as

(

select '123/43356/789' author from dual

)

SELECT AUTHOR FROM

(

    SELECT DISTINCT rn, LEVEL, 

    SUBSTR (author, INSTR (author, base, 1, LEVEL) + len, INSTR (author, base, 1, LEVEL + 1) - INSTR (author, base, 1, LEVEL) - len ) author FROM 

    (

        SELECT ROWNUM rn, '/' base, '/' || author || '/' author, LENGTH ('/') len FROM t

    )

    CONNECT BY LEVEL <= (LENGTH (author) - LENGTH (REPLACE (author, base))) / len - 1

)