SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

determine latitude/longitude when know address - possible in sql?

user5716448May 26 2021

Hi,

version 11.2.0.3

Can use sdo_geom.sdo_distance to get distance between 2 points when know latitutude and logitude in km.
Is there anything similar to determiene the lat/lon of a loaction when know address, postcode, country?

Any other way of calculating this in oracle?

Thanks

Added on May 26 2021

8 comments

774 views