ORACLE中树操作递归算法connect by prior

最新推荐文章于 2022-10-21 18:32:29 发布

naomi_qing

最新推荐文章于 2022-10-21 18:32:29 发布

阅读量359

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle函数文章标签： oracle 函数递归算法

本文链接：https://blog.youkuaiyun.com/naomi_qing/article/details/70571114

本文介绍了如何在Oracle数据库中使用递归查询操作`CONNECT BY PRIOR`来处理树形结构数据。通过创建并填充一个示例表`linshi_ljq`，展示了不同层次的菜单数据。详细讲解了`START WITH`、`CONNECT BY`、`PRIOR`等关键字的用法，并给出了查询子类、父类、层级、完整路径以及判断叶子节点和根节点的示例查询语句。

创建表 linshi_ljq

在其中插入数据

--父菜单
insert into linshi_ljq(value, value_meaning, parent_value_low) values(1, '父菜单1',null);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(2, '父菜单2',null);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(3, '父菜单3',null);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(4, '父菜单4',null);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(5, '父菜单5',null);
--一级菜单
insert into linshi_ljq(value, value_meaning, parent_value_low) values(6, '一级菜单6',1);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(7, '一级菜单7',1);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(8, '一级菜单8',1);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(9, '一级菜单9',2);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(10, '一级菜单10',2);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(11, '一级菜单11',2);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(12, '一级菜单12',3);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(13, '一级菜单13',3);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(14, '一级菜单14',3);
insert into linshi_ljq(value, value_meaning, parent_value_low) values(15, '一级菜单15',4);
insert into linshi_ljq(value, value_meaning, par