Oracle 递归查询

select * From V_XT_XTGNDY start with GNDYXH
IN
(
select GNDYXH From V_XT_XTGNDY WHERE XTMKXH='201'
  AND GNDYXH IN (SELECT GNDYXH FROM XT_YHFZQX WHERE YHFZBH IN (SELECT YHFZBH FROM XT_YHFZCY WHERE YHRYDM='DBA'))
)
connect by prior FLDYXH=GNDYXH

转载于:https://www.cnblogs.com/KimSky/archive/2011/04/27/2031027.html