Prostorové operátory
From Wikivyuka
Základní Spatial Operátory
Operator Description
SDO_FILTER Specifies which geometries may interact with a given geometry. SDO_JOIN Performs a spatial join based on one or more topological relationships. SDO_NN Determines the nearest neighbor geometries to a geometry. SDO_NN_DISTANCE Returns the distance of an object returned by the SDO_NN operator. SDO_WITHIN_DISTANCE Determines if two geometries are within a specified distance from one another. SDO_RELATE Determines whether or not two geometries interact in a specified way. (See for convenient alternative operators for performing specific mask value operations.)
Convenience Operators for SDO_RELATE Operations
Operator Description
SDO_ANYINTERACT Checks if any geometries in a table have the ANYINTERACT topological relationship with a specified geometry. SDO_CONTAINS Checks if any geometries in a table have the CONTAINS topological relationship with a specified geometry. SDO_COVEREDBY Checks if any geometries in a table have the COVEREDBY topological relationship with a specified geometry. SDO_COVERS Checks if any geometries in a table have the COVERS topological relationship with a specified geometry. SDO_EQUAL Checks if any geometries in a table have the EQUAL topological relationship with a specified geometry. SDO_INSIDE Checks if any geometries in a table have the INSIDE topological relationship with a specified geometry. SDO_ON Checks if any geometries in a table have the ON topological relationship with a specified geometry. SDO_OVERLAPBDYDISJOINT Checks if any geometries in a table have the OVERLAPBDYDISJOINT topological relationship with a specified geometry. SDO_OVERLAPBDYINTERSECT Checks if any geometries in a table have the OVERLAPBDYINTERSECT topological relationship with a specified geometry. SDO_OVERLAPS Checks if any geometries in a table overlap (that is, have the OVERLAPBDYDISJOINT or OVERLAPBDYINTERSECT topological relationship with) a specified geometry. SDO_TOUCH Checks if any geometries in a table have the TOUCH topological relationship with a specified geometry.
