1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| select * from test
PARENT ENFANT TRI
---------- ---------- ----------------------
A Aa 1
A Ab 2
Ab Aba 1
Ab Abb 2
A Ac 3
B Ba 1
B Bb 2
Bb Bba 1
Bb Bbb 2
B Bc 3
10 rows selected
select parent,enfant,tri, level
from test
start with parent = 'A'
connect by parent = prior enfant
order by parent, tri, enfant
PARENT ENFANT TRI LEVEL
---------- ---------- ---------------------- ----------------------
A Aa 1 1
A Ab 2 1
A Ac 3 1
Ab Aba 1 2
Ab Abb 2 2
5 rows selected |
Partager