测试用例数据

复制代码
create table tab_connect_by (parent number,child number,flag VARCHAR(5));  
insert into tab_connect_by (PARENT, CHILD, FLAG)values (4, 2, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (5, 4, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (5, 3, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (15, 10, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (15, 5, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (17, 9, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (17, 8, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (38, 15, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (38, 17, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (38, 6, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (26, 13, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (26, 1, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (26, 12, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (18, 11, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (18, 7, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (7, 4, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (null, 38, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (null, 26, 'Y');
insert into tab_connect_by (PARENT, CHILD, FLAG)values (null, 18, 'Y');
commit; 
复制代码

 

posted @   Faith_zhang  阅读(405)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
点击右上角即可分享
微信分享提示