对oracleçconnect by ä¹ä¸æ¯ç¹å«æ
é¿ï¼åªä¼ç»è®¡æä¸ä¸ªIDçææåIDï¼æ æ³åå°test1é£æ ·çå±æ¬¡å±ç°ï¼æ´å«æDB2çwith t asäºï¼
æ±å¤§ç¥ä»¬å¸®å¿è§£å³ï¼å¦æå¯è½çè¯ï¼oracleçä¾åä¹ç»ä¸ä¸ªåèå¦ä¹ ä¸ï¼
æµè¯èæ¬ï¼
create table test2(id varchar(10),name varchar(20),pid varchar(10));
insert into test2 values('1','A',null);
insert into test2 values('101','B','1');
insert into test2 values('10101','C','101');
insert into test2 values('1010101','D','10101');
insert into test2 values('1010102','E','10101');
insert into test2 values('1010103','F','10101');
æç»ææå±ç°ç»æ
level1 level2 level3 level4
A B C D
A B C E
A B C F
温馨提示:答案为网友推荐,仅供参考