a guest Apr 25th, 2019 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand