Oracle Spatial Query

[DotNetGnat]

Guys,

I have the following table:

Route_ID | GEOM
-----------------
123 | SDO_GEOMETRY
124 | SDO_GEOMETRY
--
--
--

I want to write a query that lists Routes whose length is less than 25 ft...

How can I do such query on the SDO_GEOMETRY column...

I have never written a spatial query...Can someone point me to a tutorial where I can learn spatial queries...

thanks in advance...

-DNG

 

[DotNetGnat]

I guess I figured it out my self...tried using SDO_LENGTH() method...

any links for learning spatial stuff would be helpful..

-DNG