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;

 

상위부모찾는 쿼리 입니다.;;

 

제가 원하는건 형제들이 나오는건데요...

선택된 형제, 아버지 형제, 할아버지 형제.. 다 나왔으면 좋겠어요.. ㅠㅠ