3.2 ST_xxx Functions and Spatial Counterparts

The following table lists SQL Multimedia functions and the comparable Spatial SDO_GEOMETRY method or Spatial function, procedure, operator.

Note that in some cases the Oracle Spatial counterpart has more features than the SQL Multimedia function.

Table 3-1 ST_xxx Functions and SSpatial Counterparts

SQL Multimedia Function	Comparable Oracle Spatial Interface
FROM_WKB	SDO_UTIL.FROM_WKBGEOMETRY
FROM_WKT	SDO_UTIL.FROM_WKTGEOMETRY
GET_WKB	SDO_GEOMETRY.Get_WKB
GET_WKT	SDO_GEOMETRY.Get_WKT
ST_BUFFER	SDO_GEOM.SDO_BUFFER
ST_CENTROID	SDO_GEOM.SDO_CENTROID
ST_CONTAINS	SDO_CONTAINS
ST_CONVEXHULL	SDO_GEOM.SDO_CONVEXHULL
ST_COORDDIM	SDO_GEOMETRY.Get_Dims and SDO_GEOMETRY.ST_CoordDim (equivalent)
ST_CROSS	(None predefined; requires using SDO_RELATE with a complex mask)
ST_CROSSES	(None predefined; requires using SDO_RELATE with a complex mask)
ST_DIFFERENCE	SDO_GEOM.SDO_DIFFERENCE
ST_DIMENSION	SDO_GEOMETRY.Get_Dims
ST_DISJOINT	SDO_GEOM.RELATE with mask=DISJOINT
ST_DISTANCE	SDO_GEOM.SDO_DISTANCE
ST_ENVELOPE	SDO_GEOM.SDO_MBR
ST_EQUALS	SDO_EQUAL
ST_GEOMETRYTYPE	SDO_GEOMETRY.Get_GType
ST_INTERSECTION	SDO_GEOM.SDO_INTERSECTION
ST_INTERSECTS	SDO_ANYINTERACT
ST_ISVALID	SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
ST_OVERLAP	SDO_RELATE with mask=OVERLAPBDYDISJOINT + OVERLAPBDYINTERSECT
ST_RELATE	SDO_RELATE
ST_SYMDIFFERENCE	SDO_GEOM.SDO_XOR
ST_SYMMETRICDIFFERENCE	SDO_GEOM.SDO_XOR
ST_TOUCH	SDO_TOUCH
ST_TOUCHES	SDO_TOUCH
ST_UNION	SDO_GEOM.SDO_UNION
ST_WITHIN	SDO_RELATE with mask=COVERS+CONTAINS