随笔分类 -  Oracle

使用Oracle数据库的递归查询语句生成菜单树
摘要：SQL 格式 SELECT * FROM TABLE WHERE [...结果过滤语句] START WITH [...递归开始条件] CONNECT BY PRIOR [...递归执行条件] 查询所有下级 SELECT * FROM TABLE START WITH [ID in ('1','2' 阅读全文
posted @ 2020-04-26 10:03 大毛啊 阅读(579) 评论(0) 推荐(0)