菜单展开递归查询
摘要:
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 lizicheng 阅读(490) 评论(0) 推荐(0) 编辑