SELECT
T.Menu_Id,--子id
T.Parent_Menu_Id,--父id
sys_connect_by_path (t.Parent_Menu_Id, '/') path,
level, --级别
lpad(' ',(level-1)*8) || menu_name,--菜单项名称(级别显示)
t.busi_kind,
t.menu_url,--当前菜单的url
t.func_id,
t.is_used,
t.expire_date
FROM sys_menu T
where domain_id=5
START WITH parent_menu_id = 50101 --表示从哪级节点开始
CONNECT BY PRIOR T.Menu_Id = T.Parent_Menu_Id
转载于:https://my.oschina.net/rainingcn/blog/106619