oracle的树查询

select *
from PF_FORM_DISPATCH fd
connect by prior FD.FORM_ITEM_ID=FD.SUB_FORM_ITEM_ID

start with FD.FORM_ITEM_ID=4875 and FD.FORM_ITEM_ID!=FD.SUB_FORM_ITEM_ID

prior 放在哪边就是从哪边开始查