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.

1 comment:

Sandro Martins said...

Thank you! Simple and useful!