START WITH CONNECT BY PRIOR句再帰クエリを実現
414 ワード
例:
表名:tsys_organization
id pid name
6000001 bizroot A
0_1000200 6000001 B0_1000202 0_1000200 C
検出idは'0_1000202'の親idと、親idの親id......无限循环でわがまま调べて
START WITH CONNECT BY PRIOR句で実現:
表名:tsys_organization
id pid name
6000001 bizroot A
0_1000200 6000001 B0_1000202 0_1000200 C
検出idは'0_1000202'の親idと、親idの親id......无限循环でわがまま调べて
START WITH CONNECT BY PRIOR句で実現:
select t.id
from tsys_organization t
START WITH t.id='0_1000202'
CONNECT BY PRIOR t.pid=t.id