oracle递归查询

一、从上到下

 select level, id, parent_id, name, parent_name   from table  start with id = 1 connect by prior id = parent_id  order by level;

二、从下到上

 select level, id, parent_id, name, parent_name   from table  start with id = 1 connect by prior parent_id = id  order by level;

三、附带出完整路径

 select id, parent_id, name, parent_name, sys_connect_by_path(name, '/') path   from table  start with id = 1 connect by prior parent_id = id

结果中path为：/World/Asia/China/Beijing