oracle中的递归语句: start with connect by prior . 例子: pid id a b a c a e b b1 b b2 c c1 e e1 e e3 d d1 指定pid=a,选出 a b a c a e b b1 b b2 c c1 e e1 e e3 SQL语句: select parent,child from test start with pid='a' connect by prior id=pid 注意最后connect by prior id=pid中id=pid的位置不能互换.