Recursive sql, Oracle

Recursive sql

Language: Layout:


absolute service time: 1,17 sec

edit mode | history | discussion

  
LEVEL
ROOT_N
N
PAR
NAME
PAT

1
1
1
1
NULL
aa
1/4/6/3/8/2

2
2
1
4
1
dd
1/4/6/3/8/2

3
2
1
6
1
ff
1/4/6/3/8/2

4
3
1
3
4
cc
1/4/6/3/8/2

5
3
1
8
6
hh
1/4/6/3/8/2

6
4
1
2
3
bb
1/4/6/3/8/2

7
1
5
5
NULL
ee
5/9

8
2
5
9
5
ii
5/9

9
1
7
7
NULL
gg
7

λ

                                      .NET NoSQL database for rapid development