Re: Querying distances between two coordinates

From: Jeremy <>
Date: Sat, 11 Jun 2011 17:37:31 +0100
Message-ID: <MPG.285daa2ada2886a098990c_at_News.Individual.NET>

In article <ba7de41c-7ce8-465a-bc20-67c4e2484871>, says...
> On Jun 10, 12:15 pm, Jeremy <> wrote:
> > Hi this is a 10gR2 Standard Edition question.
> >
> > The requirement is to be able to calculate the distance between two co-
> > oordinates expressed as latitude and longitude.
> >

> I vaguely remember teaching a class how to do this calculation of
> distance around a spherical object in the early 1990s (with only a
> calculator) - I could probably search and find the lesson plan which
> is probably right next to the proof that 1=2. While I am searching
> for that lesson plan, see if the following article is helpful:

Thanks. Of course what I have failed to do is actually to ask the real question I wanted to answer - ultimately we need to be able to query a table to find the rows where the lat/long defined on those rows is within a user-specified radius. Are there already functions witin Oracle 10gR2 SE that provide this capability efficiently?

Received on Sat Jun 11 2011 - 11:37:31 CDT

Original text of this message