菜单展开递归查询

SELECT LEVEL,
       CONNECT_BY_ISLEAF,
       CONNECT_BY_ROOT t.PROMPT,
       SYS_CONNECT_BY_PATH(t.PROMPT, '->')
  FROM (select tt.*
          from fnd_menu_entries_vl tt
         where (tt.SUB_MENU_ID is not null or tt.FUNCTION_ID is not null)
           and tt.PROMPT is not null) t
 START WITH t.MENU_ID =
            (select fr.MENU_ID
               from fnd_responsibility_vl fr
              where fr.RESPONSIBILITY_NAME like '%总帐超级%')
CONNECT BY PRIOR t.SUB_MENU_ID = t.MENU_ID
 ORDER SIBLINGS BY t.ENTRY_SEQUENCE；

 

转载于:https://www.cnblogs.com/lizicheng/p/10558117.html