Relationship between two objects:
RELATE
Sdo_geom. RELATE--Determine how two objects interact
Within_distance
Verify:
Validate_geometry_with_context
Validate_layer_with_context
Single-Object operation:
Sdo_arc_densify
Sdo_geom. Sdo_arc_densify-simplifies, simplifies arcs to approximate polylines made up of straight lines; approximate circles to n polygons
Sdo_area
Sdo_geom. Sdo_area -Calculate the area of a polygon
Sdo_buffer
Sdo_geom. Sdo_buffer --generate buffers outside or inside the geometry
Sdo_centroid
Sdo_geom. Sdo_centroid --Calculate the centroid of a polygon
Sdo_convexhull
Sdo_geom. Sdo_convexhull --The Polygon type object that returns the convex hull of the Geometry object
Sdo_length
Sdo_max_mbr_ordinate
Sdo_min_mbr_ordinate
Sdo_mbr
Sdo_pointonsurface
Sdo_volume
Dual-target operation:
Sdo_closest_points
Sdo_geom. Sdo_closest_points -Calculates the minimum distance between two geometries and returns the two points in the geometry at the nearest hour
Sdo_distance
Sdo_geom. Sdo_distance -Calculates the distance between two geometric objects
Sdo_difference
Sdo_geom. Sdo_difference --Returns the geometry (topological differences of two geometries, minus operations)
Sdo_intersection
Sdo_geom. Sdo_intersection --Returns the geometric object (the topology intersection of two geometries, and operation)
Sdo_union
Sdo_xor
Oracle Spatial Operation Geometry method