select menu_id, sys_connect_by_path(menu_desc,'@') from dwc_menu
connect by prior  menu_id = parent_id
Posted by leebaro
,