Oracle Selecting geometries inside polygon: Difference between revisions

From WickyWiki
Created page with "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 whe..."
 
m 1 revision
 
(No difference)

Latest revision as of 07:26, 5 July 2013

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;