O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Extracting and filtering SDO_GEOMETRY elements

As we have seen, often the processing of an object cannot occur unless its SDO_ELEM_INFO attribute informs an algorithm's decision making. This section will explore the extraction of various elements and subelements from different geometry objects by processing the SDO_ELEM_INFO array.

Introducing the Oracle SDO_UTIL.Extract function

The Oracle API from 10gR1 onwards provides the SDO_UTIL.Extract element extraction function. The function is as follows:

 SDO_UTIL.Extract(
     geometry In SDO_GEOMETRY,
     element  In NUMBER,
     ring     In NUMBER DEFAULT 0
) Return SDO_GEOMETRY;
  • Geometry: [Two dimensional] geometry from which to extract the [Return] geometry.
  • Element: Number of the element in the geometry: 1 for the first ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required