例如:
--向下遍历
select * from tablename START WITH id= '111' CONNECT BY id=parentid
--不包含parentid
select * from tablename START WITH parentid= '111' CONNECT BY id=parentid
--向上遍历
select * from tablename START WITH id= '111' CONNECT BY parentid =id
--不包含parentid
select * from tablename START WITH parentid= '111' CONNECT BY parentid =id