Oracle Menu Tree

select sys_connect_by_path (substr(mnu_name,0,50) ,'-->')  as path, level
from appd_menu
start with mnu_id = 1
connect by prior mnu_id = prt_id
order by path