Hello,
I have a line table (table1) and a polygon table (table2).
I would make the intersection between one line from table1 with table2 to return the name of all plygon that intersect the line.
Here is my query:
SELECT t1table1,SDO_GEOM.SDO_INTERSECTION(t1.geometry, t2.geometry, 0.005) AS GEOM
FROM table1 t1, table2 t2
WHERE t1.ID='29'
AND SDO_GEOM.SDO_INTERSECTION(t1.geometry, t2.geometry, 0.005) IS NOT NULL;
It works. It returns the result but in any order and I would like it to return the polygon names in the order of the first which intersect the line at the beginning of line to the last which intersects the line at the end of the Line or in reverse order.
Any idea or trick please?
thank you in advance