start with를 사용한 순환 쿼리(Tree 구조)

SELECT ID,TYPE, NAME,
    (SELECT B.CONTENTS FROM CODE_CONTENTS B WHERE B.ID= C.ID) AS CONTENTS
    FROM 
        (select * from CODELIBRARY A start with PARENT_ID=10 CONNECT BY PRIOR A.ID=A.PARENT_ID) C