Could anyone help me figure out the best way to get the overlapping line segment of 2 line sdo_geometry objects?
my query looks like this:
select SDO_GEOM.SDO_INTERSECTION(SHAPE, :SHAPE, 0.5) as geomfrom MyTable where MDSYS.SDO_OVERLAPS(SHAPE, :SHAPE) = 'TRUE'the geometry objects in the table are all lines as is eth parameter being passed in, but the geometry being returned for all results is a point, not a line.
أكثر...
my query looks like this:
select SDO_GEOM.SDO_INTERSECTION(SHAPE, :SHAPE, 0.5) as geomfrom MyTable where MDSYS.SDO_OVERLAPS(SHAPE, :SHAPE) = 'TRUE'the geometry objects in the table are all lines as is eth parameter being passed in, but the geometry being returned for all results is a point, not a line.
أكثر...