Oracle9i Spatial Capabilities
 Oracle
Spatial
Spatial Data Types
Native Spatial Data
Management in the DBMS
Spatial Indexing
Fast Access to
Spatial Data
Spatial Access Through SQL
ŸSELECT STREET_NAME FROM ROADS, COUNTIES
ŸWHERE SDO_RELATE(road_geom, county_geom, ‘MASK=ANYINTERACT QUERYTYPE=WINDOW’) =‘TRUE’
ŸAND COUNTYNAME=‘PASSAIC’;