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: ST_xxx Functions and S Spatial 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 |