在oracle中通过connect by prior来实现递归查询:http://falchion.iteye.com/blog/660309 http://mengya520.blog.51cto.com/1506880/334621