测试用例数据

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;