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!

Extract X,Y from SDO_GEOMETRY / SDO POINT TYPE

1056703Nov 25 2013 — edited Jan 28 2014

Hi,

I have a table showing this data;

SDO_GEOMETRY(2001, 90112, SDO_POINT_TYPE(186858,487, 481875,513, NULL), NULL, NULL)

I need to know the X and Y values.. Whats the easiest way to do this? I did quite a bit of googling, but the whole geometry field is new for me..

Cheers

Alex

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 25 2014

Added on Nov 25 2013

#database-key-features, #spatial

2 comments

9,012 views