adventurous1
Programmer
Help!
I have a listing of hotel addresses, each with a zip code, latitude and longitude. I have another listing of customers with zip code, lat & longitude. I need to select all the customers that are within a 100 mile radius of each hotel.
Can anyone help me do this in Oracle SQL or in PL/SQL? I am a novice so any code provided will be appreciated!!!
Thanks.
I have a listing of hotel addresses, each with a zip code, latitude and longitude. I have another listing of customers with zip code, lat & longitude. I need to select all the customers that are within a 100 mile radius of each hotel.
Can anyone help me do this in Oracle SQL or in PL/SQL? I am a novice so any code provided will be appreciated!!!
Thanks.