Skip to Main Content

APEX Office Hours

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

Header container

June 13

14:00 UTC   Start Times Around the World


Oracle Application Express and Multitenant
Oracle Multitenant, first available in Oracle database 12c, over five years ago, delivers a new architecture that allows a multitenant container database to hold many pluggable databases. This presentation will provide an overview of this database feature and will go into detail about what this means for APEX installations. Exciting tips and tricks will be covered as well as a new installation option available in APEX 19.1 to exploit the Application Containers feature of Multitenant.


04:48 Introduction to Oracle Multitenant
09:36 Oracle APEX in Oracle Multitenant
13:06 Recommended Approach to Installing APEX in Oracle Multitenant
17:03 Tips & Tricks
22:16 Demo: Connecting to PDBs using ORDS and PDB Name in the URL
29:23 Demo: Fast Provisioning of a Fully Functional APEX Instance in Seconds
32:30 Demo: Using the Containers clause on the apex_workspace View to Find All PDBs with Workspaces in a CDB
34:33 Application Containers
41:20 Demo: Query cdb_applications to Find APEX Installed in Application Containers
42:48 Demo: Deploy an APEX Application in an Application Container and Patch It
51:42 Demo: Inserting into a Table Defined with SHARING=EXTENDED Data Two Ways
53:20 Demo: Applying a PSE to APEX Installed in an Application Container
59:20 Q & A

Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere. Join APEX developers and product managers for trainings and how-to's, so you can make the most of this amazing tool!

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.

Your Experts

Jason Straub
Jason Straub, Consulting Member of Technical Staff    
Jason Straub is a Consulting Member of Technical Staff for Oracle’s Developer Tools & Integration division at Oracle America. Jason has primarily worked on Oracle Application Express since joining Oracle in 2000. Jason has developed features integrating APEX with web services. Most recently, Jason works on integrating APEX with Oracle cloud offerings and installation into Oracle Multitenant. Jason holds a B.S. degree in mathematics from Ohio University’s College of Arts and Sciences.
Marc Sewtz
Marc Sewtz, Director of Software Development    
Marc Sewtz is a Senior Software Development Manager at Oracle Corporation in New York City. With over 20 years of industry experience, Marc held roles in Consulting, Sales and Product Development. Today he manages a global team of Software Developers and Product Managers working on the development of Oracle Application Express (APEX), Oracle's premier Low Code development platform for building responsive applications on Oracle Database. Marc frequently presents at international conferences, such as Oracle Open World, ODTUG Kscope, UKOUG, DOAG, APEX Connect, and Oracle Code. Marc has a Master's degree in Computer Science from the University of Applied Sciences in Wedel, Germany.
Joel Kallman
Joel Kallman, Senior Director, Software Development    
Joel is the Senior Director 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.