Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SDO_UNION

551772Jun 13 2008 — edited Jun 23 2008
Hello!

I'm new in spatial oracle but I really want to learn.
I have a table calle RegionC where I have the coordenates of all the regions in Italy and each region has a number GRUPO. I divided Italy in 5 GRUPO (grups) so now I want the coordenates of each GRUPO with all the regions in it, I mean the coordenates of the hole GRUPO.
That's why I used SDO_UNION, but I gives me nothing!!!
What am I doing wrong?
Please help me!!!!

SELECT SDO_GEOM.SDO_UNION(a.geom, m.diminfo, c.geom, m.diminfo)
FROM scott.regionc a, scott.regionc c, user_sdo_geom_metadata m
WHERE m.table_name = 'SCOTT.REGIONC' AND m.column_name = 'GEOM'
AND a.grupo = 3;

SELECT SDO_GEOM.SDO_UNION(a.geom, c.geom, 0.5)
FROM scott.regionc a, scott.regionc c, user_sdo_geom_metadata m
WHERE m.table_name = 'SCOTT.REGIONC' AND m.column_name = 'GEOM'
AND a.grupo = 3;

Thank you very much in advance!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2008
Added on Jun 13 2008
12 comments
1,284 views