select connect_by_isleaf isleaf,
1、connect_by_isleaf是否是子节点;
2、sys_connect_by_path(tb.package_id, '|')
3、start with tb.level_parent like '%|0|-1'
4、connect by prior tb.level_child = tb.level_parent;
select connect_by_isleaf isleaf,
1、connect_by_isleaf是否是子节点;
2、sys_connect_by_path(tb.package_id, '|')
3、start with tb.level_parent like '%|0|-1'
4、connect by prior tb.level_child = tb.level_parent;