Oracle Spatial User's Guide and Reference Release 8.1.6 A7713201 

This chapter contains descriptions of the geometric functions and procedures shown in Table 151.
Function/Procedure  Description 

Determines how two objects interact. 

Determines if a geometry is valid. 

Determines if all geometries in a layer are valid. 
Examines two geometry objects to determine their spatial relationship. This function is available in two forms. See the Usage Notes for more information.
SDO_GEOM.RELATE (layername1, SDO_GID1, mask, [layername2,] SDO_GID2)
SDO_GEOM.RELATE (layername1, SDO_GID1, mask, X_tolerance, Y_tolerance,
SDO_ETYPE, num_ordinates, X_ordinate1, Y_ordinate1 [,...,Xn, Yn]
[,SDO_ETYPE, num_ordinates, X_ordinate1, Y_ordinate1 [,...,Xn, Yn]])
The SDO_GEOM.RELATE function can return three types of answers:
SDO_GEOM.RELATE
is in the SELECT clause of the SQL statement.
The data type is VARCHAR2.
Use the first form of the function to examine two stored geometric objects.
Use the second form of the function to compare a stored object against a userdefined object. You can specify up to 123 vertices for a singleelement geometry. If the geometry has multiple elements, the total number of arguments passed, including SDO_ETYPE, num_ordinates, and the list of vertex coordinates, cannot exceed 255 values.
The following relationships can be tested:
Mask values can be combined using the logical Boolean operator OR. For example, `INSIDE + TOUCH' returns 'INSIDE + TOUCH' or 'FALSE' depending on the outcome of the test.
None.
Provides a consistency check for valid geometry types. This function checks the representation of the geometry from the tables against the element definitions.
SDO_GEOM.VALIDATE_GEOMETRY (layername,SDO_GID)
This function returns one of the following:
The data type is VARCHAR2.
This function checks for the following:
None.
Examines a layer to determine if the stored geometries follow the defined rules for geometric objects.
SDO_GEOM.VALIDATE_LAYER (layername, result_table)
layername 
Specifies the name of the layer to examine. 
result_table 
Specifies the name of the result table. 
This function fills the result table with validation results.
Create an empty result table prior to calling this function. The format of the result table is: (sdo_gid number, result varchar2).
This function checks for the following:
None.

Copyright © 1999 Oracle Corporation. All Rights Reserved. 
