oracle递归查询

oracle递归查询 

Select * from …. Where [结果过滤条件语句]

Start with  [and起始条件过滤语句]

Connect by prior [and中间记录过滤条件语句] 

Ex:

select   *
from  mm_bom
start  with  mm_bom.ppartid = 111
connect  by  nocycle prior mpartid  =  ppartid

转载于:https://www.cnblogs.com/mmmhhhlll/archive/2008/08/13/1267215.html