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;
自上而下,向下抓层级树结构:
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;