菜单展开递归查询

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

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；