connect by prior start with

 

 connect by prior start with  实现递归查询。

 

 

 

如图是地区表部分字段，该表是按照当前节点父节点存储的。

 

我要查询222的所有上级地区（包括本级地区）

 

select * from area connect by prior supid = id start with id = 222

 

 

如果我要是想按照地区级别为1的查询呢？

 

select * from area where arealevel = 1  connect by prior supid = id start with id = 222