Tuesday, January 19, 2010

Converting Oracle SDO_GEOMETRY Fields To Points

Just because Google didn't help.

SELECT Alias.FieldName.SDO_POINT.X, Alias.FieldName.SDO_POINT.Y
FROM TableName Alias

The alias seems to be necessary.
Posted by at
Labels: , , ,

1 comment:

Unknown said...

Thank you! Simple and useful!

Thursday, April 18, 2013 8:17:00 pm

Post a Comment

Subscribe to: Post Comments (Atom)