ST_GEOMETRY vertices should be easier to access (Oracle).
Currently, ST_GEOMETRY vertices are obscured in a BLOB/LOB column within the shape object, which makes accessing the vertices difficult.
An alternative idea might be: store the vertex ordinates in a more transparent datatype, such as a varray, a nested table column, or some other table collection datatype — as an additional/separate attribute within the existing SHAPE object column (not to be confused with creating an entirely new column in the table).
That would make it a lot easier to work with ST_GEOMETRY vertices.
We're aware there are workarounds like cross joins and parsing WKT. But they're too clunky & slow. An easier-to-access collection datatype would be better.
