select isleaf, path
from (select connect_by_isleaf isleaf,
sys_connect_by_path(code, '/') path
from hbms_area_grid
start with name like '%name%'
connect by prior pcode = code)
where isleaf = '1';
from (select connect_by_isleaf isleaf,
sys_connect_by_path(code, '/') path
from hbms_area_grid
start with name like '%name%'
connect by prior pcode = code)
where isleaf = '1';
sys_connect_by_path 查询子节点路径
connect_by_isleaf 是否为子节点或者最后一个节点 1代表是 0代表否