This content has been marked as final. Show 1 reply
Do you mean, you have two sets of Longitude and Latitude coordinates, and you want to calculate the shortest distance around the earth's surface between them?
The SDO_GEOM package has the SDO_DISTANCE function that takes two geometries (e.g. points), a tolerance value and optional units value. E.g. to find the distance between your coordinates and (24.2,46.3):
0.0001,'unit=km') AS DISTANCE_BETWEEN_POINTS