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

Constructing cross-database SQL

Constructing SQL that can run across multiple database vendor databases is a design goal for a lot of applications in the hope that their development investment can create better return on investment through streamlined porting and reducing maintenance. The goal of standards (whether SQLMM, OGC SFA or SQL92) is to facilitate the achievement of these design goals. The presentation of the SQL/MM geometry type hierarchy and function set in this chapter is to introduce the only foundation that exists to support cross-platform spatial SQL today. But, as we shall see, nothing is perfect.

Is database independence possible?

It is common to meet developers and architects who believe that the only sound approach to using a ...

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