Create Applications with Oracle APEX in Autonomous AI Database

You can create applications with Oracle APEX on Autonomous AI Database.

• About Oracle APEX

  Oracle APEX is trusted worldwide to deliver mission-critical, data-driven applications that are secure, scalable, and built on the Oracle AI Database.

• Access Oracle APEX Administration Services

  Each Autonomous AI Database includes a dedicated instance of Oracle APEX. You can use this instance to create multiple workspaces. A workspace is a shared work area where you can build applications. You create workspaces in Oracle APEX Administration Services.

• Create Oracle APEX Workspaces in Autonomous AI Database

  An Autonomous AI Database instance does not have pre-created Oracle APEX workspaces. Create a workspace if you have not already done so or use these instructions to create additional workspaces.

• Access Oracle APEX App Builder

  Use Oracle APEX App Builder to create and manage APEX applications and application pages. The App Builder home page displays all installed applications in the current workspace.

• Create Oracle APEX Developer Accounts

  Oracle APEX developers need a developer account in each workspace where they wish to build applications.

• Load Data from the Cloud into Oracle APEX

  Using Oracle APEX SQL Workshop, you can declaratively load data from Object Store into the database schema associated with your Oracle APEX workspace.

• Use JSON Data with Oracle APEX

  You can use Oracle APEX to create applications with JSON data. You must first create a view to extract the required attributes from the JSON data and maps them into columns of a relational view.

• Use Web Services with Oracle APEX

  You can interact with both SOAP and RESTful style web services from Oracle APEX in your Autonomous AI Database instance.

• Send Email from Oracle APEX

  You can use the APEX_MAIL package to send email from Oracle APEX applications deployed in Autonomous AI Database.

• Control Oracle APEX Upgrades

  Oracle maintains Oracle APEX instance in your Autonomous AI Database by applying new releases and Patch Set Bundles. When a new APEX release becomes available in your region, you can choose when to apply it during the upgrade window. Oracle applies Patch Set Bundles automatically during scheduled maintenance windows.

• Access Oracle APEX, Oracle REST Data Services, and Built-in Database Tools Using a Vanity URL

  By default, access to Oracle APEX apps, REST endpoints and built-in database tools on Autonomous AI Database is through the oraclecloudapps.com domain name. You may optionally configure a vanity URL (ie. a custom domain) that is more relevant for your organization or project.

• Oracle APEX Limitations on Autonomous AI Database

  This section summarizes restrictions and limitations of Oracle APEX included in Oracle Autonomous AI Database and APEX Service.

• Autonomous AI Database Limitations in APEX Service

  This section summarizes key restrictions and limitations of Autonomous AI Database in APEX Service.