This content has been marked as final. Show 3 replies
This is known as reverse geocoding
Check out 10g documentation to start with.
or 11g documentation including geocoding web service.
Edited by: Luc Van Linden on Aug 25, 2009 9:25 AM
You can also read this white paper on Geocoder.
Note that there is no api to do exactly what you are looking for to get all matching addresses for a given long/lat.
The reverse geocoder returns the closest possible address to a given long/lat location.