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!

Route distance

fabiano.santosJan 2 2007 — edited Jan 9 2007

Hi people... first of all: HAPPY NEW YEAR!!!

Now, I'm needing a SQL that returns the distance of a route. I could have at last 2 points and need to know the distance of this points. For 2 points it's easy, I can use the SDO_DISTANCE. And when I have 3 or more points? Is there a way that we can calculate/return the full distance?

I mean something like that: imagine that the distance from point 1 to 2 is 0.5 miles and the distance from point 2 to 3 is 1.2 miles. Plus this values and we take 1.7 miles, but if we take the distance from point 1 to 3 is 1 mile. So, I want the value 1.7, the distance along all points of the route.

Oracle version: Oracle9i Enterprise Edition Release 9.2.0.6.0

Thank you all.

Regards,
Fabiano

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2007

Added on Jan 2 2007

#database-key-features, #spatial

15 comments

1,263 views