oracle遞迴查詢記錄

標籤：style   io   art   ar   line   oracle   ef   on   

1. start with  開始的id  connect by prior 開始的id=父id

2. level 層級

3.執行個體

select * from (

select a.*,level tt from biz_district a start with district_id=8 connect by prior district_id=parent_id

) where tt=3

select a.district_id,

       a.district_name,

       b.district_id   as district_id_1,

       b.district_name as distract_name_1

  from (select * from biz_district where parent_id = 8) a

  left join (select *

               from (select a.*, level tt

                       from biz_district a

                      start with district_id = 8

                     connect by prior district_id = parent_id)

              where tt = 3) b

    on a.district_id = b.parent_id