By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with cte as (
select sdo_geometry('MULTILINESTRING((1 1 1, 2 2 2),(3 3 3, 4 4 4))') as shape from dual union all
select sdo_geometry('MULTILINESTRING((5 5, 6 6),(7 7, 8 8),(9 9, 0 0))') as shape from dual union all
select sdo_geometry('MULTILINESTRING((1 1, 2 2))') as shape from dual
)
select
--a.object_value, --DB<>FIDDLE doesn't output SDO_GEOMETRIES correctly; it returns an empty resultset, which is misleading. https://topanswers.xyz/databases?q=2008
sdo_util.to_wktgeometry(a.object_value)
from
cte,
table(sdo_util.extract_all(shape)) a
| SDO_UTIL.TO_WKTGEOMETRY(A.OBJECT_VALUE) |
|---|
| LINESTRING (1.0 1.0 1.0, 2.0 2.0 2.0) |
| LINESTRING (3.0 3.0 3.0, 4.0 4.0 4.0) |
| LINESTRING (5.0 5.0, 6.0 6.0) |
| LINESTRING (7.0 7.0, 8.0 8.0) |
| LINESTRING (9.0 9.0, 0.0 0.0) |
| LINESTRING (1.0 1.0, 2.0 2.0) |