Oracle 계층형 Query
SELECT MENU_NO AS "menuNo" , MENU_ORDR AS "menuOrdr" , MENU_NM AS "menuNm" , UPPER_MENU_NO AS "upperMenuId" , MENU_DC AS "menuDc" , RELATE_IMAGE_PATH AS "relateImagePath" , RELATE_IMAGE_NM AS "relateImageNm" , PROGRM_FILE_NM AS "progrmFileNm" , 'HOME' || SYS_CONNECT_BY_PATH(MENU_NM, ' > ') AS "menuNmPath" /* 상위부터 하위까지 경로 명 표시 */ , CONNECT_BY_ROOT M..