35.7 SDO_UTIL.CONVERT3007TO3008
Format
SDO_UTIL.CONVERT3007TO3008( geometry IN SDO_GEOMETRY ) RETURN SDO_GEOMETRY;
Description
Converts an input three-dimensional multisurface geometry (SDO_GTYPE 3007) to a simple solid geometry (SDO_GTYPE 3008).
Parameters
Usage Notes
Note:
SDO_UTIL.CONVERT3007TO3008 function is not supported in Oracle Autonomous Database Serverless deployments.For information about SDO_GEOMETRY attributes for 3D geometries, see Three-Dimensional Spatial Objects.
This function does not check the validity of the returned simple solid geometry. To check the validity of a geometry object, use the SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT function.
Examples
The following example converts an input three-dimensional multisurface geometry (SDO_GTYPE 3007) to a simple solid geometry (SDO_GTYPE 3008). It assumes that a table named GEOMS3D exists with at least a numeric ID column and a column named GEOM of type SDO_GEOMETRY containing three-dimensional multisurface geometries.
SELECT sdo_util.convert3007to3008(g.geom) FROM geoms3d g WHERE g.id=1;
Parent topic: SDO_UTIL Package (Utility)