APEX 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. Highlights 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! AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit