SDO_GEOM.SDO_DIAMETER_LINE
Note: This feature is available starting with Oracle Database 12c Release 1 (12.1.0.2).
Format
SDO_GEOM.SDO_DIAMETER_LINE(
geom IN SDO_GEOMETRY,
dim IN SDO_DIM_ARRAY
) RETURN NUMBER;or
SDO_GEOM.SDO_DIAMETER_LINE(
geom IN SDO_GEOMETRY,
tol IN NUMBER
) RETURN NUMBER;Description
Returns a line string geometry reflecting the length of the diameter of a geometry object.
Parameters
geom
Geometry object.
dim
Dimensional information array corresponding to geom, usually selected from one of the xxx_SDO_GEOM_METADATA views (described in Geometry Metadata Views).
tol
Tolerance value (see Tolerance).
Usage Notes
This function can be used for circle and non-circle geometry objects. The input geometry does not need to contain any curves.
The returned diameter length is the maximum distance between any two points in the geometry object. (For a formal definition of diameter, see a college-level mathematics textbook or other appropriate reference source.)
The input geometry can have no more than two dimensions.
If a point geometry is specified, the function returns 0 (zero).
Examples
The following example returns line strings reflecting diameter length of each geometry object stored in the COLA_MARKETS table. (The example uses the definitions and data from Simple Example: Inserting_ Indexing_ and Querying Spatial Data.)
SELECT name, SDO_GEOM.SDO_DIAMETER_LINE(shape, 0.005)
FROM cola_markets;
NAME
--------------------------------
SDO_GEOM.SDO_DIAMETER_LINE(SHAPE,0.005)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z),
--------------------------------------------------------------------------------
cola_a
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
1, 1, 5, 7))
cola_b
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
8, 1, 5, 7))
cola_c
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
3, 3, 6, 5))
cola_d
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
8, 7, 8, 11))