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'
/

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Error using locator_Within_distance Operator
Next Topic: Re: object type tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 02 18:23:49 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.