21.7 SDO_AGGR_POINTAPPEND

Format

SDO_AGGR_POINTAPPEND(
  geom  SDO_GEOMETRY 
) RETURN SDO_GEOMETRY;

Description

Returns a geometry object that is the collection of the specified point geometry objects.

Parameters

geom

Point geometry objects.

Usage Notes

This function is similar to the SDO_UTIL.APPEND function. However, it can only support point geometry objects, and return the collection of these point objects.

Examples

The following example returns the collection of the centroid objects in the COLA_MARKETS table. (The example uses the definitions and data from Simple Example: Inserting_ Indexing_ and Querying Spatial Data.)

SELECT SDO_AGGR_POINTAPPEND(SDO_GEOM.SDO_CENTROID(shape))
  FROM cola_markets;

SDO_AGGR_POINTAPPEND(SDO_GEOM.SDO_CENTROID(SHAPE))(SDO_GTYPE, SDO_SRID, SDO_POIN
--------------------------------------------------------------------------------
SDO_GEOMETRY(2005, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1, 4), SDO_ORDINATE_ARRAY(
3, 4, 6.45454545, 3.75757576, 4.73333333, 3.93333333, 8, 9))