Extract X,Y Co-ordinates in Number format
I have a table with a field containing point data in MDSYS.SDO_GEOMETRY format.
eg.
SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(423185203, 4515343624, NULL), NULL, NULL)
I need the co-ordinates in Number format.
What i need to be able to do is, parse the first three digits of each X and Y co-ordinate, concatenate then insert them in another field in the table.
I can use the SUBSTR(X-Coordinate,1,3) function to get the first three digits, but the coordinate must be in number format to do so.
I was thinking of using the
SDO_GEOM.SDO_MAX_MBR_ORDINATE & SDO_GEOM.SDO_MIN_MBR_ORDINATE functions to get the coordinates, but then i've no way of knowing which is X and which is Y.
Any help would be much appreciated.
OS: Windows 2000
DB: Oracle 9i