--查询所有
select * from t_address t;
--向下找包含自己
select * from t_address start WITH addr_id='?' connect by prior addr_id = addr_pid ;
--向下找不包含自己
select * from t_address start WITH addr_pid='?' connect by prior addr_id = addr_pid ;
--向上找包含自己,显示整个路径
select * from t_address start WITH addr_id='?' connect by prior addr_pid = addr_id ;
--向上找 包含自己的下一级和下一级的整个路径
select * from t_address start WITH addr_pid='?' connect by prior addr_pid = addr_id ;