8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Oracle Cloud : APEX Application Development Service (APX) - Create Service
The APEX Application Development Service is a low-code development environment based on APEX, available from the Oracle Cloud. This article provides a run through of creating a new APEX Application Development (APX) service on the Oracle Cloud.
The screens change a little with each quarterly release of Oracle Cloud. Even so, the screen shots in this article will give you a good idea of what is involved.
- Create APEX Application Development (APX) Service
- Create a New Workspace
- SQL Developer Web
- Database
- Miscellaneous
Related articles.
- Oracle Cloud : APEX Application Development Service (APX) - Import Data
- Cloud : All Articles
- Oracle Cloud : Autonomous Transaction Processing (ATP) - Create Service
- APEX : All Articles
- Oracle REST Data Services (ORDS) : SQL Developer Web
Create APEX Application Development (APX) Service
Log into Oracle Cloud.
Open the menu by clicking the hamburger on the top-left of the screen. Click on the "APEX Application Development > APEX Instances" option.
Select the compartment you want to build the service in, then click the "Create APEX Service" button.
Enter the details of the service you want to create, then click the "Create APEX Service" button. Remember the password for the ADMIN user. You will need this later.
You are taken to the "APEX Instance Details" screen. Wait while the service is provisioned. You will see the state is marked as "Provisioning".
Once complete the state changes to "Available" on the "APEX Instance Details" screen.
Create a New Workspace
From the "APEX Instance Details" screen, click the "Launch APEX" button. On your first login you are presented with the basic "Administration Services" login screen. Enter the password for the ADMIN user, defined during the service creation, then click the "Sign In to Administration" button.
On subsequent attempts you will be presented with the normal APEX login screen comprising of the workspace, username and password boxes. To log into the administration services, use the INTERNAL workspace and the ADMIN username and password.
Click the "Create Workspace" button.
Enter the workspace details and click the "Create Workspace" button. Here we've made the database user and the workspace name match, but you don't have to.
Log into the workspace in the normal way.
You are then presented with the normal APEX development environment.
SQL Developer Web
From the "APEX Instance Details" screen, click the "Launch SQL Developer Web" button. Enter your ADMIN user credentials and click the "Sign in" button.
You are presented with the SQL Developer Web screen.
You can read more about SQL Developer Web here.
Database
Clicking the database link on the "APEX Instance Details" screen takes you to the "Autonomous Database Details" screen.
Although this looks like the normal Autonomous Transaction Processing (ATP) administration screen, some of the functionality is not available unless you upgrade the service to a full ATP service.
Miscellaneous
- The APEX Application Development Service is an Autonomous Transaction Processing (ATP) service with some of the functionality disabled. You don't get access to all the ATP administration screens, and you don't get SQL*Net access to the database. It is priced lower than the equivalent ATP service.
- An APEX instance can be upgraded to a full ATP service at any time, but this will incur additional costs.
- If you have existing Autonomous Transaction Processing (ATP) services, you will see them listed on the "APEX Instances" screen. You can use the simplified interface to interact with them.
- An APEX Application Development Service can be created via the normal Autonomous Database creation screens, but the APEX Instances screens are simpler to use.
- When first released the APEX Application Development Service was not available on the free tier, but in April 2021 it was added to the free tier.
- There is no Bring Your Own Licence (BYOL) option for this service.
- Like all autonomous databases, automatic backups are performed by default, but if you want to perform manual backups, you will need to configure an object store.
For more information see:
- Oracle Cloud Infrastructure Delivers New Low-code Service to Simplify Application Development
- Build Apps Fast in Oracle Cloud Infrastructure - Announcing New Oracle APEX Application Development for Low-Code Developers
- Oracle APEX Application Development : Documentation
- Oracle Cloud : APEX Application Development Service (APX) - Import Data
- Cloud : All Articles
- Oracle Cloud : Autonomous Transaction Processing (ATP) - Create Service
- APEX : All Articles
- Oracle REST Data Services (ORDS) : SQL Developer Web
Hope this helps. Regards Tim...