Building Command Line Tools to Boost APEX and Database Development

Session Number: 8573
Track: Application Express
Sub-Categorization: APEX Integration
Session Type: Tips, Techniques and Tuning
Primary Presenter: John Scott [Director - APEX Evangelists]
Time: Jun 26, 2019 (03:30 PM - 04:30 PM)
Room: 613/614, Level 6

Speaker Bio: John Edward Scott has been using Oracle since its version seven (about 1993) and has used nearly every release since then. He has had the good fortune of working on a wide range of projects for a diverse group of clients. He was lucky enough to start using Oracle Application Express when it was first publicly released and has enjoyed working with it nearly every day since.

John is an Oracle ACE Director. He was named Application Express Developer of the Year in 2006 by Oracle Magazine and is the author of the best-selling book Pro Oracle Application Express. He is also the co-founder of APEX Evangelists (, which specializes in providing training, development, and consulting specifically for the Oracle Application Express product.

Technologies or Products Used: Oracle APEX

Session Summary for Attendees:  Over the years of using APEX, there are a number of tasks that I perform often, such as:
• Generating ERDs
• Performing database diffs to identify which objects are different
• Extracting code from the database
• Many more

To streamline this process, I’ve written some command-line tools to make this easier, faster, and scriptable. We're going to show you just how easy it is to build these types of tools and how they can be leveraged within your workflow.