自上而下,向下抓层级树结构:
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;
转载于:https://www.cnblogs.com/sikuaiwu/p/11543127.html