Skip to Main Content

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!

sdo_geom.sdo_intersection

3764055Sep 18 2018 — edited Sep 19 2018

I would like to know if you can make an intersection between lines and polygons in oracle spatial, I'm trying to do it in the following way and I can not do it.

thanks

create table prueba.INTER AS (SELECT s.NAME,  p.codi ,

      SDO_GEOM.SDO_LENGTH(

    SDO_GEOM.SDO_INTERSECTION(p.geometry, s.Geometry,0.01),

    0.01 ) length

  FROM   prueba.dren p, prueba.telf s

WHERE SDO_ANYINTERACT (s.geometry, p.geometry) = 'TRUE')

   ;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2018
Added on Sep 18 2018
10 comments
3,888 views