oracle树结构查询

 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';

sys_connect_by_path 查询子节点路径

connect_by_isleaf 是否为子节点或者最后一个节点 1代表是 0代表否