Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT menu_tree
- FROM (SELECT substr(sys_connect_by_path(im.id_item_menu, ','), 2) menu_tree, connect_by_root(im.id_item_menu_super) root_parent
- FROM SEG_ITEM_MENU im
- WHERE im.id_item_menu IN (select id_item_menu from vw_permissao_acesso where login = ?)
- CONNECT BY PRIOR im.id_item_menu = im.id_item_menu_super
- ORDER BY im.id_item_menu)
- WHERE root_parent IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement