2 Welcome to Oracle APEX Application Development

Oracle APEX Application Development (APEX Service) is a low cost, Oracle Cloud service offering convenient access to the Oracle APEX platform for rapidly building and deploying low-code applications.

About Oracle Cloud Infrastructure

Oracle Cloud Infrastructure (OCI) is a set of complementary cloud services that enable you to build and run a wide range of applications and services in a highly available hosted environment.

Oracle Cloud Infrastructure offers high-performance compute capabilities (such as physical hardware instances) and storage capacity in a flexible overlay virtual network that is securely accessible from your on-premises network.

Use Oracle Infrastructure as a Service (IaaS) offerings to quickly set up the virtual machines, storage, and networking capabilities you need to run just about any kind of workload. Your infrastructure is managed, hosted, and supported by Oracle.

Use Oracle Platform as a Service (PaaS) offerings to provision ready-to-use environments for your enterprise IT and development teams, so they can build and deploy applications, based on proven Oracle databases and application servers.

Web Browser Requirements

Oracle APEX Application Development requires a JavaScript-enabled browser and supports the current and prior major release of Google Chrome, Mozilla Firefox, Apple Safari, and Microsoft Edge.

What's Included

This topic describes the components included in Oracle APEX Application Development (APEX Service).

APEX Service includes the following components:

  • Oracle APEX

  • Oracle Database Actions (SQL Developer Web)

  • Oracle REST Data Services (ORDS)

  • OCI Console UI for APEX Service Instances

  • Oracle Autonomous Transaction Processing database optimized for APEX Service

Service Resources

Service resources include:

  • Maximum of 128 OCPU

  • Maximum of 128 TB of storage

About Oracle APEX

Oracle APEX is a low-code development platform that enables you to build scalable, secure enterprise applications with world-class features that can be deployed anywhere.

Oracle APEX provides you with an easy-to-use browser-based environment to load data, manage database objects, develop REST interfaces, and build applications which look and run great on both desktop and mobile devices. You can use APEX to develop a wide variety of solutions: import spreadsheets and develop a single source of truth in minutes, create compelling data visualizations against your existing data, deploy productivity applications to elegantly solve a business need, or build your next mission-critical data management application.

Oracle APEX embraces SQL. Anything you can express with SQL can be easily employed in an APEX application. Oracle APEX also enables low-code development, providing developers with powerful data management and data visualization components that deliver modern, responsive end-user experiences out of the box. Instead of writing code by hand, you are able to use intelligent wizards to guide you through the rapid creation of applications and components.

Oracle APEX provides a preconfigured, fully managed and secured environment to both build and deploy world-class data-centric applications. There are no limits on the number of developers or end users for your applications.

Configuration, patching, monitoring, and upgrading of all Oracle APEX components is fully managed by Oracle, leaving you free to focus on developing your solutions and solving your business problems. Oracle APEX enables your organization to be more agile and develop solutions faster, for less cost, and with greater consistency. You can adapt to changing requirements with ease. And you can empower professional developers, citizen developers, and everyone else.

About Oracle Database Actions

Oracle Database Actions (SQL Developer Web) is a browser-based application that uses Oracle REST Data Services (ORDS) to provide many of the database development and administration features of desktop-based Oracle SQL Developer.

Note:

Oracle Database Actions was previously named Oracle SQL Developer Web

Database Actions provides a web-based interface that enables you to execute queries and scripts, create database objects, load data, build data models, and monitor database performance. Key features include:

  • Development:

    • Run SQL statements and scripts in the worksheet

    • Design Data Modeler diagrams using existing objects

    • Work with REST data services

    • Work with JSON data

  • Data Tools:

    • Data Load

    • Data Insights

    • Business Models

  • Administration:

    • Administration features

See Also:

About Database Actions in Using Oracle Database Actions

About Oracle REST Data Services

Oracle REST Data Services (ORDS) functions as a communications broker between the Web browser and the Oracle APEX objects in the Oracle database by mapping browser requests into database stored procedure calls.

Oracle REST Data Services is preconfigured and available for all Oracle APEX instances. With the default ORDS, Oracle performs any required configuration, patching, and maintenance.

Oracle REST Data Services also enables access to Oracle APEX application data using custom REST APIs. Developers can then utilize these APIs from any language environment without installing and maintaining client drivers in the same way they access other external services using the most widely adopted API technology: REST.

Note:

APEX Service supports the creation of custom REST APIs. Direct access of the REST-SQL interface is prohibited.

About the OCI Console UI for APEX Service Instances

Access an APEX Service by navigating to the OCI Console UI for APEX Instances.

Navigate to the OCI Console Sign-In Page and sign in. In the upper right corner next to the Oracle Cloud logo, click the Navigation Icon. From the Oracle Cloud Infrastructure left navigation list, select Developer Services and then APEX Application Development or APEX Instances. The APEX Instances page appears.

The Oracle Cloud Infrastructure console includes two dedicated UI pages:

  • APEX Instances. Use the APEX Instances page to create a new APEX Service instance. If you have an APEX Service, find the service name. Then, click the Row menu and select View Details, Launch APEX, or Launch Database Actions.

  • APEX Instance Details. Use the APEX Instance Details page to view details about your service. To sign in, click the Launch APEX or Launch Database Actions buttons.

About the Oracle Autonomous Database Included with APEX Service

APEX Service includes an optimized version of Autonomous Database for Transaction Processing and Mixed Workloads.

The underlying database included with APEX Service is an adapted Autonomous Database for Transaction Processing and Mixed Workloads. It is suitable for transactional workloads, small- to medium-sized analytic workloads, and mixed workloads that include both transactional and analytic processing