父子级菜单的查询

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