Skip to Main Content

How to create separate polygons from multi-polygon

User_F1YPTDec 8 2022

Hello,
I'm having difficulty creating a table of individual polygons from a table of multi-polygons (gtype 2007). I've used SDO_UTIL.EXTRACT_ALL to create an array of geometries, not sure how to create separate records for each geometry.
I read the article https://www.spdba.com.au/how-to-extract-elements-from-the-result-of-an-sdo_intersection-of-two-polygons/, but I either don't understand it or I'm doing something wrong.
Any help is appreciated.

Comments
Post Details
Added on Dec 8 2022
4 comments
40 views