Expert Oracle Application Express

I guess I’m a published author now. 🙂


Today the new edition of Expert Oracle Application Express was released. My contribution is chapter 12: Map Integration, where I show how to integrate maps, such as Google, or Leaflet maps into an APEX application. Here is the introduction from the book:

Any database application that contains location data, such as addresses or geographic coordinates, may benefit from displaying this data on a map. It may be of further benefit, to allow users to interact with this data by associating it with other data, or even perform geometric calculations against it.

In this chapter we will explore some options to free the geographic data from its confines of the database tables, and render it in useful ways on interactive maps. To accomplish this we will look at a number of tools and techniques available to us in APEX, the Oracle database, and some publicly available APIs.

We will learn how to turn address data into geographic coordinates and how to use these coordinates to display addresses on a map. Further we will take a look at various mapping APIs, and how to use Oracle’s powerful spatial features to find relationships between geographic data points.

You can get the book from Amazon. If you do, please don’t forget to leave a comment.

2 thoughts on “Expert Oracle Application Express

  • November 25, 2015 at 8:56 am

    Haha, I emailed you this morning for a suggestion for a good Apex book…

  • March 28, 2017 at 12:23 am

    I am referencing your example in Ch12 using leaflet, I have tried all the versions but using apex 5.1 any ideas.
    Leaflet 1.0.3 Stable version, released on January 23, 2017.
    Leaflet 1.1-dev In-progress version, developed on the master branch.
    Leaflet 0.7.7 Legacy version, released on November 18, 2013 and last updated on October 26, 2015.
    Whick specific version did you use and do you have a sample app I can download.

Comments are closed.