try this: select count(*) CONT from MYTABLE s where s.geometry.get_Gtype() in (1,2,3,4,5,6,7) r, dennis -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Number-of-geometry-types-in-Oracle-FeatureClass-tp5161882p5169321.html Sent from the FDO Users mailing list archive at Nabble.com.