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