select * from t_s_da_sec_var r
start with c_da_code='FZ_FZ'
connect by nocycle prior r.c_da_code_p=r.c_da_code
;
select * from t_s_da_sec_var r
start with c_da_code_p='[root]'
connect by nocycle prior r.c_da_code=r.c_da_code_p
select * from t_s_da_sec_var r
start with c_da_code='FZ_FZ'
connect by nocycle prior r.c_da_code_p=r.c_da_code
;
select * from t_s_da_sec_var r
start with c_da_code_p='[root]'
connect by nocycle prior r.c_da_code=r.c_da_code_p
转载于:https://www.cnblogs.com/wglwgl/p/6099307.html