父子级菜单的查询

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

posted @ 2016-11-24 20:16  学无止境,前进  阅读(750)  评论(0编辑  收藏  举报