clear markdown feedback
clear markdown feedback
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
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)
 hidden batch(es)