lidj

摘要： oracle 父子节点 查询1）从父节点到所有子节点SELECT t.ID id,RPAD( '- ', 8*(LEVEL-1), ' -' ) || l.MEANING name,t.MENU_BAR_ID menuBraId,t.PARENT_ID parentId,t.DISPLAY_ORDER displayOrder,CONNECT_BY_ROOT NAME ROOT,CONNECT_BY_ISLEAF ISLEAF,LEVEL,SYS_CONNECT_BY_PATH(NAME, '<') pathFROM MENU_ITEM t 阅读全文