Skip to Main Content
Forums

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!

ZIP Radius on Oracle

Kodiak_SeattleJul 16 2009 — edited Jul 21 2009
So I realize that my question might be a little too general. But if I have a ZIP code say 98275 and I want to get a 40 mile radius of all the customer ZIP codes that are within 98275, how would I do that ?

Our Database stores information about customers through Trillium which assigns a latitude and longitude.

I am thinking that all I would need would be to do a Function, then a Stored Procedure and then call the Stored Procedure in the SQL ?

Has anyone done anything like that in Oracle ?

If so can you share the code ?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2009
Added on Jul 16 2009
10 comments
1,209 views