Re: database function to get distance between 2 latitude/longitude points
Date: Fri, 1 May 2009 08:24:22 -0700 (PDT)
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
- 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!
> > Oracle Locator is a subset of the Spatial option, and
> is included in all
> > editions of Oracle.