10.1.3.5 썸네일형 리스트형 [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 ; 더보기 [ODI Repository] Query related with Procedures and Packages -- Using ODI Repository Info by SQL Query -- Get IP Address Information of Jobs related with OdiFtp.. (in ODI Work Repository) -- ODI Version: ODI 10g 10.1.3.5.1 -- Created by Cheon Jeonghyeon -- WideTNS Co., Ltd SELECT PROJECT_NAME, -- 프로젝트 명 FOLDER_PATH, -- 구성된 폴더 경로 PACK_NAME, -- 패키지 명 STEP_NAME, -- 단계 명 STEP_TYPE, -- 단계 명령 타입 REGEXP_SUBSTR(TXT,'([[:digit:]]+\.?){4}') IP Address -- 연결 네트워크 IP.. 더보기 이전 1 다음