Keyword | CPC | PCC | Volume | Score | Length of keyword |
---|---|---|---|---|---|

sdo_geom.sdo_distance units | 1.16 | 1 | 3464 | 91 | 27 |

sdo_geom.sdo_distance | 0.66 | 0.7 | 5119 | 72 | 21 |

units | 0.51 | 0.8 | 605 | 97 | 5 |

Keyword | CPC | PCC | Volume | Score |
---|---|---|---|---|

sdo_geom.sdo_distance units | 0.39 | 0.6 | 7903 | 16 |

SDO_GEOM subprograms are supported for two-dimensional geometries only, except for the following, which are supported for both two-dimensional and three-dimensional geometries: SDO_GEOM.RELATE with (A) the ANYINTERACT mask, or (B) the INSIDE mask (3D support for solid geometries only)

Two-object operations: SDO_CLOSEST_POINTS, SDO_DISTANCE, SDO_DIFFERENCE, SDO_INTERSECTION, SDO_UNION, SDO_XOR The geometry subprograms are listed Table 24-1, and some usage information follows the table. Determines how two objects interact.

If the input data is three-dimensional and geodetic, a 3D SRID must be used for the geometries; otherwise, the results will be incorrect. The following example returns the shortest distance between cola_b and cola_d.