Skip to Main Content

APEX Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

July 16

14:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Optimizing grocery delivery routes using Oracle APEX, Oracle Autonomous Database and Google Maps APIs
In this special edition of APEX Office Hours, we will be joined by Santhosh Jose, who is a Principal Applications Engineer in the Oracle HCM product development organization. During the pandemic, Santhosh volunteered his time to help deliver groceries to the elderly. After delivering groceries a few times, he quickly realized that the list of addresses were not as efficient as they could be. This is the classic "Traveling Salesman" problem in computer science ( ) - what is the shortest possible route between a list of destinations?

To solve this problem, Santhosh turned to Oracle APEX & Oracle Autonomous Database to help solve this problem. In a short amount of time, Santhosh built a fully functional "Route Builder" application, which, given a list of addresses, will help determine the most efficient route between those addresses. To facilitate navigation by a driver, Santhosh also integrated Google Maps.

This session will be comprised of two parts - an introduction and background of Santhosh Jose and how he found Oracle APEX, and then a description, explanation and demonstration of the RouteBuilder app.

Your Experts

Joel Kallman
Joel Kallman, Vice President of Software Development    
Joel is the Vice President of Software Development at Oracle America, Inc., managing the development and product management of Application Express (APEX). He started working with Oracle Database in 1992 and joined Oracle in 1996. Joel's passion is to make customers extraordinarily successful with the Oracle Database, SQL and Oracle Application Express (APEX). He is a proud alumnus of The Ohio State University, College of Engineering, with a Bachelor's degree in Computer Engineering.
Santhosh Jose
Santhosh Jose, Principal Applications Engineer
Santhosh Jose is a Principal Applications Engineer at Oracle. His association with Oracle began as a system integrator that was providing application maintenance and production support for Oracle ERP/HCM implementations. He then joined Oracle consulting, where he focused on implementing Oracle ERP/HCM solutions for customers. He is currently part of the Oracle development team that builds out new features for the Oracle HCM Cloud product. In his day job, he primarily works with Oracle Database and Oracle Application Development Framework. Oracle APEX is his go-to platform for personal projects and for building productivity tools at work.