Oracle9
i
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
’
;