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

Understanding and using SDO_ORDINATES

When creating new spatial processing functions, sometimes only the SDO_GEOMETRY's array of ordinates (SDO_ORDINATES) need be processed. Two functions will be created that use two different methods for processing the ordinates. These functions are drawn from real-life situations that will be described.

Two things need to be understood about the SDO_ORDINATES attribute of the SDO_GEOMETRY object.

Firstly, the name of the SDO_GEOMETRY attribute that stores ordinate data is called SDO_ORDINATES, which is different from the underlying data type, which is called SDO_ORDINATE_ARRAY. This is the same as in a database table; an attribute may be called GID, but its data type Integer SDO_ORDINATE_ARRAY is defined as follows: ...

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