[ODI Repository] get folder hierarchy in Designer - Version 10.1.3.5

-- Using ODI Repository Info by SQL Query

-- ODI Version: ODI 10g 10.1.3.5.1

-- Created by Cheon Jeonghyeon 

-- WideTNS Co., Ltd
 -- FOLDER PATH 가져오기

SELECT I_FOLDER,

  PROJECT_NAME,

  SYS_CONNECT_BY_PATH(FOLDER_NAME, '/')

FROM SNP_FOLDER F, SNP_PROJECT P

WHERE 1=1

AND F.I_PROJECT = P.I_PROJECT

START WITH PAR_I_FOLDER IS NULL 

CONNECT BY PRIOR I_FOLDER = PAR_I_FOLDER

;