hi all,

i would like to compare a geom variable (v_geom) with those in a table, in order to ascertain whether v_geom duplicates of one (or more) of those contained in the table.

the way i've looked at doing this is to use a query like the following:

select *
from geom_table
where (sdo_within_distance(geom, v_geom,
'distance=0 unit=km')='TRUE');

geom_table is made up of a number of fields, including a geom point field of mdsys.sdo_geometry type.

this doesn't seem to be picking up duplicates though...

any ideas?