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=5START WITH parent_menu_id = 50101 --表示从哪级节点开始CONNECT BY PRIOR T.Menu_Id = T.Parent_Menu_Id