Oracle Centroid of a specific geometry
From WickyWiki
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';
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';