Is there any way of merging non contiguous polygons using the SDO_AGGR_UNION or a similar dissolve function?
When i run the below query in oracle sql developer i managed to convert geometry type from polygon(2003) to multipolygon(2007), but in a gis system some polygons are not included on preview.
select shape from (
select nationalcode as nt,SDO_AGGR_UNION(SDOAGGRTYPE(shape, 0.5)) as shape
from auadmunits where nationalcode = '1225' group by nationalcode) ;
I know that union is for adjacent shapes, but i am wondering if anyone else has faced this issue and has found an approach, not only handling oracle spatial.