Příklady použití prostorových operátorů

From Wikivyuka
Revision as of 11:09, 25 April 2011 by Dur30 (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SELECT c.mkt_id, c.name

FROM cola_markets c  
WHERE SDO_NN(c.shape,    sdo_geometry(2001, NULL, sdo_point_type(10,7,NULL), NULL, NULL), 'sdo_num_res=1') = 'TRUE';