SDO WITHIN DISTANCE

From Wikivyuka
Revision as of 16:24, 18 August 2012 by Dur30 (talk | contribs) (Příklad 1)

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

Příklad 1

Zjišťujeme, které prvky jsou ve vzdálenosti 2 od obdélníku (4,4, 5,5).

SELECT c.name, c.shape FROM cola_markets c 
WHERE SDO_WITHIN_DISTANCE(c.shape,
SDO_GEOMETRY(2003, NULL, NULL, 
SDO_ELEM_INFO_ARRAY(1,1003,3),
SDO_ORDINATE_ARRAY(4,4, 5,5)),
'distance=2') = 'TRUE';

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