Oracle-start with...connect by prior... 进行递归查询

Oracle-start with…connect by prior… 进行递归查询

语法：

start with 条件1 connect by prior 条件2

例:

selec * from user start with id = '1' connect by prior id = pid

解析：
start with:条件1作为第一个查询条件，
connect by prior 是连接条件，其中用prior表示本条记录，connect by prior id = pid 意思是本条的记录的id是下条记录的pid。

例子：

SELECT *
  FROM PrpDcompany
 WHERE centerflag = '1'
 Start With comcode = '1501'
Connect By Prior uppercomcode = comcode
       and (PRIOR centerflag is null or PRIOR centerflag != '1')
       And Prior comcode != comcode
 order by comcode