By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| MULTILINE_NUM | PART_NO | SDO_UTIL.TO_WKTGEOMETRY(E.ELEM) |
|---|---|---|
| 1 | 1 | LINESTRING (1.0 1.0 1.0, 2.0 2.0 2.0) |
| 1 | 2 | LINESTRING (3.0 3.0 3.0, 4.0 4.0 4.0) |
| 2 | 1 | LINESTRING (5.0 5.0, 6.0 6.0) |
| 2 | 2 | LINESTRING (7.0 7.0, 8.0 8.0) |
| 2 | 3 | LINESTRING (9.0 9.0, 0.0 0.0) |
| 3 | 1 | LINESTRING (1.0 1.0, 2.0 2.0) |
| MULTILINE_NUM | PART_NO | SDO_UTIL.TO_WKTGEOMETRY(E.ELEM) |
|---|---|---|
| 1 | 1 | LINESTRING (1.0 1.0 1.0, 2.0 2.0 2.0) |
| 1 | 2 | LINESTRING (3.0 3.0 3.0, 4.0 4.0 4.0) |
| 2 | 1 | LINESTRING (5.0 5.0, 6.0 6.0) |
| 2 | 2 | LINESTRING (7.0 7.0, 8.0 8.0) |
| 2 | 3 | LINESTRING (9.0 9.0, 0.0 0.0) |
| 3 | 1 | LINESTRING (1.0 1.0, 2.0 2.0) |