By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36300 in the last week).
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
