CHAPTER 7Manipulating SDO_GEOMETRY in Application Programs

So far, you have seen how to define and load spatial objects using the SDO_GEOMETRY type. You have also seen how to read spatial objects from SQL using SQL*Plus. In this chapter, we cover how to manipulate SDO_GEOMETRY types in the PL/SQL and Java programming languages.

Note that there are actually few occasions when you need to write explicit code to manipulate SDO_GEOMETRY types in your application. In most cases, you can directly examine the contents of an SDO_GEOMETRY in SQL. For instance, you can obtain the geographical coordinates from an SDO_GEOMETRY object as shown in Listing 7-1.

Listing 7-1. Extracting Coordinates

SQL> SELECT b.name, b.location.sdo_point.x b_long, b.location.sdo_point.y ...

Get Pro Oracle Spatial for Oracle Database 11g now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.