distance between points
Posted by:
n p
Date: February 02, 2008 11:01AM
Hi, I need to select the coordinates that are closest to the input coordinates, but since I'm running 4.1 and there is no implementation of DIFFERENCE(g1, g2), to do this I suppose I need to calculate the Eucledian distance which requires separate latitude/longitude coordinates, but I have 'POINT(529924 104198)'.
Can anyone see a way of doing this considering I don't have separate lat/lon values?
Thanks very much.
Subject
Views
Written By
Posted
distance between points
4654
February 02, 2008 11:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.