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

Summary

This chapter has been an introduction to the basics of programming new functionality based on the SDO_GEOMETRY data type's attributes and methods. New functions were created that showed you how to interpret and manipulate the SDO_ELEM_INFO and SDO_ORDINATES attributes both alone and together using SQL and PL/SQL.

New functionality is often built on top of existing or new functions. Such functionality needs to be organized so that it is understandable, maintainable, and accessible. This chapter therefore introduced different methods for packaging such functionality with an emphasis on the use of an object type called T_GEOMETRY. The chapter concluded with some practical functions for sorting and vectorizing geometries.

In Chapter 7, Editing, ...

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