The following was provided by Greg Krakow of the Georgia Natural Heritage Program.

The Oracle Spatial query below selects all eos within 5 kilimeters (5000 meters) of a point with XY coordinates 447811 and 3545342 respectively. The number "2001" means the geometry is a 2D point. "26917" means the coordinates are in UTM Zone 17 North, NAD83 (EPSG:26917).

SELECT eo_id
FROM eo_shape
WHERE sdo_geom.sdo_distance(eo_shape.shape, SDO_GEOMETRY(2001, 26917,SDO_POINT_TYPE(447811, 3545342, NULL),NULL,NULL), 1) < 5000