oracle中的递归语句:
例子:
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语句:
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