Oracle Centroid of a specific geometry

From WickyWiki
Revision as of 07:26, 5 July 2013 by Admin (talk | contribs) (3 revisions)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
select * from mdm_metadata where 
  SDO_WITHIN_DISTANCE(
		SHAPE, SDO_GEOM.SDO_CENTROID(
				(select SHAPE from Table1 where id=1),0.00000005)
		,'distance=0')='TRUE';