SQL> SELECT * FROM TEST;ID NA PA
-- -- --
1 E
2 B 1
3 D 4
4 A
5 C 4SQL> SELECT RPAD(' ',(LEVEL-1)*3)||NAME
2 FROM TEST
3 CONNECT BY PRIOR ID=PARENTID
4 START WITH ID IN (SELECT ID FROM TEST WHERE PARENTID IS NULL);RPAD('',(LEVEL-1)*3)||NAME
---------------------------------------------------------------------E
B
A
D
C
-- -- --
1 E
2 B 1
3 D 4
4 A
5 C 4SQL> SELECT RPAD(' ',(LEVEL-1)*3)||NAME
2 FROM TEST
3 CONNECT BY PRIOR ID=PARENTID
4 START WITH ID IN (SELECT ID FROM TEST WHERE PARENTID IS NULL);RPAD('',(LEVEL-1)*3)||NAME
---------------------------------------------------------------------E
B
A
D
C
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货