父子关系表级联递归查询

最新推荐文章于 2021-09-25 19:24:45 发布

weixin_30575309

最新推荐文章于 2021-09-25 19:24:45 发布

阅读量405

点赞数

原文链接：http://www.cnblogs.com/mwd-banbo/p/10176047.html

版权

select MENU_ID_ from MENU connect by prior MENU_ID_ = PARENT_MENU_ID_ start with MENU_ID_ = ?;
select MENU_ID_ from MENU where MENU_STATUS_ = 1 connect by prior MENU_ID_ = PARENT_MENU_ID_ start with MENU_ID_ = ?; -- 查询后过滤
select MENU_ID_ from (select * from MENU where MENU_STATUS_ = 1) connect by prior MENU_ID_ = PARENT_MENU_ID_ start with MENU_ID_ = ?; -- 查询前过滤

转载于:https://www.cnblogs.com/mwd-banbo/p/10176047.html