Home » Server Options » Spatial » Re: Spatial data retrival(Querying) using locator_within_distance
Re: Spatial data retrival(Querying) using locator_within_distance [message #75772] |
Sat, 06 October 2001 14:42 |
Sharad Agrawal
Messages: 1 Registered: October 2001
|
Junior Member |
|
|
execute the query as below:
SELECT A.NAME,A.AOI FROM rd_loc2 A WHERE MDSYS.LOCATOR_WITHIN_DISTANCE (A.shape,MDSYS.SDO_GEOMETRY(1, 1, mdsys.sdo_point_type(47500,47500,0),NULL, NULL), 'distance=2000 UNITS=MILE') = 'TRUE'
/
----------------------------------------------------------------------
|
|
|
Goto Forum:
Current Time: Thu Apr 17 01:55:15 CDT 2025
|