本文介绍了如何在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, parent_value_low)
最低0.47元/天 解锁文章
2330
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
