菜单展开递归查询
摘要: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_ME...
阅读全文
posted @ 2019-03-19 13:43
posted @ 2019-03-19 13:43