Convert LAT/LONG to X/Y
748220Mar 29 2010 — edited Mar 29 2010Hello all,
i've searched this forum to see how I can convert LAT/LONG values to XY coordinates.
I've found this:
SELECT
sdo_geometry(2001, 8307, null, sdo_elem_info_array(1, 1003, 1),
sdo_ordinate_array(52.849497, 5.723975, 52.883151, 5.999025))
FROM DUAL
I thought that when i executed this query, i'd see 2 values. But i was wrong.
Is there a function that will return the XY when I give the LAT/LONG values ???