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的位置不能互换.