# Haversine formula in Oracle SQL

5 min readApr 5, 2024

When calculating the distance between two point on earth you have choice between Haversine and Vincenty. The Haversine and Vincenty formulas are both used to calculate distances between two points on the Earth’s surface, typically given their latitude and longitude coordinates. However, there are some key differences between the two:

**Accuracy:****— Haversine Formula:**The Haversine formula provides a relatively…