New answers tagged oracle
I don't understand your question. When you merge multiple geometries together (using SDO_AGGR_UNION) those that touch or overlap are merged into one element. Those that are disjoint become separate elements. You need to clarify what exactly you are trying to achieve and what you expect as result.
Top 50 recent answers are included