with temp as(
SELECT '687' menu_id, '메뉴1' menu_name, '0' up_menu_id, 1 depth FROM dual
UNION ALL SELECT '12','메뉴2', '687', 2 FROM dual
UNION ALL SELECT '26','메뉴3', '12', 3 FROM dual
UNION ALL SELECT '310','메뉴4', '26', 4 FROM dual
UNION ALL SELECT '697','메뉴5', '26', 4 FROM dual
UNION ALL SELECT '13','메뉴6', '687', 2 FROM dual
UNION ALL SELECT '27','메뉴7', '13', 3 FROM dual
UNION ALL SELECT '730','메뉴8', '27', 4 FROM dual
UNION ALL SELECT '28','메뉴9', '13', 3 FROM dual
UNION ALL SELECT '731','메뉴10', '28', 4 FROM dual
UNION ALL SELECT '732','메뉴11', '28', 4 FROM dual
)
SELECT menu_id , menu_name, up_menu_id, depth
FROM temp
START WITH menu_id = '732'
CONNECT BY menu_id = PRIOR up_menu_id;
상위부모찾는 쿼리 입니다.;;
제가 원하는건 형제들이 나오는건데요...
선택된 형제, 아버지 형제, 할아버지 형제.. 다 나왔으면 좋겠어요.. ㅠㅠ
|