8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Vm » Here

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.

Related articles.

Create APEX Application Development (APX) Service

Log into Oracle Cloud.

Oracle Cloud Dashboard

Open the menu by clicking the hamburger on the top-left of the screen. Click on the "APEX Application Development > APEX Instances" option.

APEX Instances Menu

Select the compartment you want to build the service in, then click the "Create APEX Service" button.

APEX Application Development Service : APEX Instances

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.

APEX Application Development Service : Create APEX Service

You are taken to the "APEX Instance Details" screen. Wait while the service is provisioned. You will see the state is marked as "Provisioning".

APEX Application Development Service : Provisioning

Once complete the state changes to "Available" on the "APEX Instance Details" screen.

APEX Application Development Service : APEX Instance Details

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.

APEX Application Development Service : Administration Services Login

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.

APEX Application Development Service : Administration Services

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.

APEX Application Development Service : Create Workspace

Log into the workspace in the normal way.

APEX Application Development Service : Workspace Login

You are then presented with the normal APEX development environment.

APEX Application Development Service : Workspace

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.

APEX Application Development Service : Autonomous Database Details

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

For more information see:

Hope this helps. Regards Tim...

Back to the Top.