3.2 ST_xxx Functions and Spatial and Graph Counterparts

Table 3-1 lists SQL Multimedia functions and the comparable Oracle Spatial and Graph SDO_GEOMETRY method or Spatial and Graph function, procedure, operator. Note that in some cases the Oracle Spatial and Graph counterpart has more features than the SQL Multimedia function.

Table 3-1 ST_xxx Functions and Spatial and Graph Counterparts

SQL Multimedia Function	Comparable Oracle Spatial and Graph 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_GEOM.RELATE with `mask=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_GEOM.RELATE with a complex mask)
ST_CROSSES	(None predefined; requires using SDO_GEOM.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_GEOM.RELATE with `mask=EQUAL`
ST_GEOMETRYTYPE	SDO_GEOMETRY.Get_GType
ST_INTERSECTION	SDO_GEOM.SDO_INTERSECTION
ST_INTERSECTS	SDO_GEOM.RELATE with `mask=OVERLAPBDYDISJOINT + OVERLAPBDYINTERSECT`
ST_ISVALID	SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
ST_OVERLAP	SDO_GEOM.RELATE with `mask=CONTAINS`
ST_RELATE	SDO_RELATE, SDO_GEOM.RELATE
ST_SYMDIFFERENCE	SDO_GEOM.SDO_XOR
ST_SYMMETRICDIFFERENCE	SDO_GEOM.SDO_XOR
ST_TOUCH	SDO_GEOM.RELATE with `mask=TOUCH`
ST_TOUCHES	SDO_GEOM.RELATE with `mask=TOUCH`
ST_UNION	SDO_GEOM.SDO_UNION
ST_WITHIN	SDO_GEOM.RELATE with `mask=COVERS+CONTAINS`