Oracle Selecting geometries inside polygon
From WickyWiki
Select geometries that are fully or partially within a geometry, do not select geometries that touch from the outside. The selection geometry is (select geoColum2 from Table2 where id=1).
select geoColumn1 from table1 t1, table2 t2 where SDO_RELATE(t1.geoColumn1 , t2.geoColumn2 , 'mask=inside+coveredby+overlapbdyintersect+overlapbdydisjoint+equal+on') = 'TRUE' and t2.id=1;