回答編集履歴
1
answer
CHANGED
|
@@ -16,7 +16,7 @@
|
|
|
16
16
|
(
|
|
17
17
|
SELECT parent
|
|
18
18
|
, child
|
|
19
|
-
, sys_connect_by_path( q.child, '/' )
|
|
19
|
+
, sys_connect_by_path( q.child, '/' )
|
|
20
20
|
, level
|
|
21
21
|
, case
|
|
22
22
|
when level = 1
|
|
@@ -54,7 +54,7 @@
|
|
|
54
54
|
|
|
55
55
|
■結果
|
|
56
56
|
```result
|
|
57
|
-
parent
|
|
57
|
+
parent child path hierarchy root
|
|
58
58
|
------------------------------------------------------
|
|
59
59
|
root A001 /A001 1 A001
|
|
60
60
|
A001 B001 /A001/B001 2 A001
|