Skip to Main Content
Forums

Database Software

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!

Distance between zipcodes

568915Aug 7 2007 — edited Aug 8 2007
Want to find distance between two zipcodes that have their latitude and longitude stored in a table.

The table is as follows

CREATE TABLE distance (zipcode VARCHAR2, LNG NUMBER, LAT NUMBER)

I couldn't come up with a calculation or understand the mathematical calculation on line.. Can you help me with some stored procedure or straight query that will do..?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2007
Added on Aug 7 2007
#database-key-features, #spatial
2 comments
1,925 views