oracle树查询

数据表(area)

id                name           parent_id

1                  中国                  0

2                  湖北                  1

3                  广州                  1

4                  深圳                  3

5                  珠海                  3

6                  深圳南山区       4

 

select id from area start with id=3 connect by prior id=parent_id

 

结果：

3

4

5

6