Oracle Recursive query logging

1. Start with ID connect started by prior id= parent ID

2. Level levels

3. Example

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