Re: database function to get distance between 2 latitude/longitude points

Remember also, that even if the point data is stored as lat/lon instead of an SDO_GEOMETRY object, you can still create a spatial index on it to leverage the nearest neighbor/sdo_interact type functions that require a spatial index as a primary filter for the operation.

That capability is highlighted here in 9.2.1

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14255/sdo_exten.htm#i1005799

• On Thu, 4/30/09, Rich Jesse <rjoralist_at_society.servebeer.com> wrote:

> From: Rich Jesse <rjoralist_at_society.servebeer.com>
> Subject: Re: database function to get distance between 2 latitude/longitude points
> To: oracle-l_at_freelists.org
> Date: Thursday, April 30, 2009, 12:00 PM
> Ahhh, my new Nugget of Oracle Licensing Nuances of the Day.
>
> Thanks, Jason!
>
> Rich
>
> > Oracle Locator is a subset of the Spatial option, and
> is included in all
> > editions of Oracle.
>
> --
> http://www.freelists.org/webpage/oracle-l
      

--
http://www.freelists.org/webpage/oracle-l