Oracle中递归查询抓有层级结构的表的数据

自上而下,向下抓层级树结构:

select * from daa_f
start with daachnl = '01'
connect by nocycle prior daachnl = daa002;

  自下而上,向上抓层级树结构:

select * from daa_f
start with daachnl = '01'
connect by nocycle daachnl = prior  daa002;

  

posted @ 2019-09-18 16:06  四块五  阅读(855)  评论(0)    收藏  举报