SDO NN DISTANCE

From Wikivyuka
Revision as of 08:06, 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 užití SDO_NN_DISTANCE jako parametru při zjišťování nejbližších sousedů.

SELECT c.mkt_id, c.name, SDO_NN_DISTANCE(1) dist
FROM cola_markets c
WHERE SDO_NN(c.shape, sdo_geometry(2001, NULL,
sdo_point_type(10,7,NULL), NULL, NULL),
'sdo_num_res=2', 1) = 'TRUE' ORDER BY dist;

Zpět na stránku s příklady operátorů