I have a locations table in the Oracle database. Where locations table has following column name
id,location_name, latitude, longitude
id location_name latitude longitude
1 Delhi 28.679504758473485 77.20351947904817
2 Noida 28.558074142030005 77.37841373931448
I want to fetch the nearest location based on the current user location and a certain distance range limit. Suppose the current user location is
current_latitude=28.68326297621283
current_longitude=77.21922687309795
radius=1 km
I have a development project in Laravel and the database is Oracle. Please help me to share the correct oracle query to fetch records from the database.