Advertisement
Guest User

Untitled

a guest
Apr 25th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. SELECT menu_tree
  2. FROM (SELECT substr(sys_connect_by_path(im.id_item_menu, ','), 2) menu_tree, connect_by_root(im.id_item_menu_super) root_parent
  3. FROM SEG_ITEM_MENU im
  4. WHERE im.id_item_menu IN (select id_item_menu from vw_permissao_acesso where login = ?)
  5. CONNECT BY PRIOR im.id_item_menu = im.id_item_menu_super
  6. ORDER BY im.id_item_menu)
  7. WHERE root_parent IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement