Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get the coords of a mdsys.sdo_geometry

412289Jan 22 2004 — edited Feb 18 2004

Hi!

Is there anybody who can tell me a sql*plus statement to get the coordinates (sdo_ordinate_array) of an mdsys.sdo_geometry?

Or do I have to tokenize the response I get by selecting the whole mdsys.sdo_geometry?

SHAPE(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
SDO_GEOMETRY(3003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARRAY(8, 0, 0, 12, 7, 10, 4, 7, 0, 8, 0, 0))

What I want to get are the three 3D Coordinates!!

thanks for your help!
Joerg

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 17 2004

Added on Jan 22 2004

#database-key-features, #spatial

6 comments

2,740 views