Database Software

hi

i am trying to generate aggregate polygons for adjacent polygons (if polygon touch with other polygon) as below. The sql has created single aggregate polygon (multi polygon) of all (200 in number) polygons (even if they dont touch)

SQL> select sdo_aggr_union(sdoaggrtype(a.geometry, 0.5)) geometry from intpoly a;

Then i tried as below, but no use..i am getting single multi polygon.

SQL> select sdo_aggr_union(sdoaggrtype(a.geometry,0.5)) geometry from intpoly a, intpoly b where sdo_relate(a.geometry, b.geo
metry, 'mask=TOUCH')='TRUE' and a.eid!=b.eid;

any suggestions.. ??