Select all the cities within a particular area:
select c.city, c.pop90
from cities c
where mdsys.sdo_relate (
c.location,
mdsys.sdo_geometry (3, null, null,
mdsys.sdo_elem_info_array (1,3,3),
mdsys.sdo_ordinate_array (-109, 37, -102, 40)),
'mask=ANYINTERACT querytype=WINDOW LAYER_GTYPE=POINT') = 'TRUE';
No comments:
Post a Comment