一、从上到下
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