I am working with Oracle spatial and have a table with MULTIPOLYGONS. How can I find the database entries where the polygons of a multipolygon overlap - within the same geometry?
So, a function that checks the polygons of a multipolygon for overlapping.
I found several examples how to compare polygons in order to find overlapping polygons stored in a different row or in a different table:
SELECT * FROM GEOTAB TabA, GEOTAB TabB WHERE TabA.ID = 1234 and SDO_OVERLAPS(TabA.GEOM, TabA.GEOM) = 'TRUE'
but what I need is something like:
Select * FROM GEOTAB where SDO_OVERLAPSINTERNAL(GEOM) = 'TRUE'