Oracle Application Express

APEX is a declarative, rapid web application development tool for the Oracle database.

APEX is a no cost option.

Requirements

SGA and PGA at least 300 MB.
Oracle database release 11.2.0.4 or higher
JavaScript enabled browsers
Access to a web listener (preferably Oracle REST Data Services (ORDS) because both Embedded PL/SQL Gateway and Oracle HTTP Server and mod_plsql are deprecated.
Oracle XML DB must be installed for full development environment (not for runtime only installations)

The four primary user roles are

Instance adminstrators

the Superusers

Worskspace adminsitrators

perform task that are specific to a workspace

Developers

create applications

Users

consume the applications

Web server

APEX offers its functionality over a web server, for example over Oracle REST Data Services.

The default context root for accessing Oracle Application Express through Oracle REST Data Services is /ords.

The APEX related accounts are created when $ORACLE_HOME/apex/apexins.sql is executed. These accounts are:

C:/Oracle/19/apex/apex_rest_config.sql also configures RESTful web services and creates two additional user accounts:

`APEX_REST_PUBLIC_USER`	is used for the execution of resource templates or APEX sessions.
`APEX_LISTENER`	is used by Oracle REST Data Services to access the schema objects in the `APEX_XXXXXX` schema containing resource templates and OAuth data. This uses is not used for execution of resource templates or APEX sessions.

apexins.sql creates APEX_PUBLIC_USER user with a random password. So, this password needs to be changed.

alter user APEX_PUBLIC_USER identified by apexSecret;

Starting in 2018, APEX release numbers correspond to the year in which a version was released.