Sdo nn

From Wikivyuka
Revision as of 07:53, 22 March 2012 by Dur30 (talk | contribs)

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

Příklad 1

Dotaz na zjištění nejbližších 3 prvků od definovaného bodu (zde sdo_point_type(10,7,NULL))


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=3') = 'TRUE'; -- počet návratových prvků určuje parametr sdo_num_res