In oracle spatial, I can do this to get a list of varrays for each geometry record
select t.geometry.sdo_ordinates from table t
and i can do this to return the individual coordinates for one of those varrays
select * from table(select t.geometry.sdo_ordinates from table t where rownum = 1)
but what i would really like is a string with those coordinates concatenated together, for each varray
I know i can do this in pl/sql, but is there is a way to do this just in sql?