WITH t(pipe_id, part_id, start_x, start_y, start_z, end_x, end_y, end_z) AS
(
SELECT 'pipe_001', 'part_001', 20094.0766, 12552.3570, 119.0750, 20094.0766, 12530.1568, 119.0750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_002', 20094.9516, 12561.9812, 123.5750, 20133.1370, 12561.9812, 123.5750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_003', 20094.0766, 12553.1570, 122.7750, 20094.0766, 12553.1570, 119.8750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_004', 20094.0766, 12561.1062, 123.5750, 20094.0766, 12553.9570, 123.5750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_005', 20094.9516, 12529.2818, 119.0750, 20095.0676, 12529.2818, 119.0750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_006', 20097.3768, 12529.2818, 117.5750, 20114.8770, 12529.2818, 117.5749 FROM dual
UNION ALL SELECT 'pipe_001', 'part_007', 20095.7583, 12529.2818, 118.7889, 20096.6861, 12529.2818, 117.8611 FROM dual
UNION ALL SELECT 'pipe_001', 'part_008', 20094.9516, 12561.9812, 123.5750, 20094.0766, 12561.1062, 123.5750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_009', 20094.0766, 12553.9570, 123.5750, 20094.0766, 12553.1570, 122.7750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_010', 20133.1370, 12561.9812, 123.5750, 20133.5870, 12561.8312, 123.5750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_011', 20094.0766, 12530.1568, 119.0750, 20094.9516, 12529.2818, 119.0750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_012', 20095.0676, 12529.2818, 119.0750, 20095.7583, 12529.2818, 118.7889 FROM dual
UNION ALL SELECT 'pipe_001', 'part_013', 20096.6861, 12529.2818, 117.8611, 20097.3768, 12529.2818, 117.5750 FROM dual
UNION ALL SELECT 'pipe_001', 'part_014', 20094.0766, 12553.1570, 119.8750, 20094.0766, 12552.3570, 119.0750 FROM dual
)
SELECT a.*
     , LEVEL lv
     , SYS_CONNECT_BY_PATH(part_id, '-') p
  FROM t a
 START WITH NOT EXISTS (SELECT 1 FROM t
                         WHERE pipe_id = a.pipe_id
                           AND end_x = a.start_x
                           AND end_y = a.start_y
                           AND end_z = a.start_z
                        )
 CONNECT BY PRIOR pipe_id = pipe_id
   AND PRIOR end_x = start_x
   AND PRIOR end_y = start_y
   AND PRIOR end_z = start_z
;

마농님 감사합니다.

괜찮으시다면, 한가지만 더 여쭙겠습니다.

새롭게 레벨이 시작될때마다 하나의 그룹으로 묶어서 새로운 Part 그룹이름을 부여하고 싶습니다.

그리고, Level은 그룹내의 일련번호로 사용하면 좋겠습니다.

같은 트리에 있는것 끼리 그룹핑하여 이름을 부여하는 방법이 궁금합니다.

part_group, levlel

1, 1

1, 2

2, 1

2, 2

2, 3

2, 4

...

CONNECT_BY_ROOT로 해결했습니다.

도움주신 마농님께 감사드립니다.

SELECT a.*

, CONNECT_BY_ROOT part_group

,level part_seq

, SYS_CONNECT_BY_PATH(part_id, '-') p