2 Welcome to Oracle APEX in Oracle Cloud

Learn about Oracle APEX in Oracle Cloud.

  • 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.
  • About Oracle APEX Cloud Deployment Options
    Rapidly build and deploy scalable and secure applications in the cloud with the world's most popular enterprise low-code application platform.
  • 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 APEX Web Browser Requirements
    Oracle APEX requires a JavaScript-enabled browser and supports the current and prior major releases of Google Chrome, Mozilla Firefox, Apple Safari, and Microsoft Edge.
  • What's Included in APEX Service
    Learn about the service resources and components included with APEX Service.

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 empower professional developers, citizen developers, and everyone else.

See Also:

Oracle APEX Release 24.2

Parent topic: Welcome to Oracle APEX in Oracle Cloud

About Oracle APEX Cloud Deployment Options

Rapidly build and deploy scalable and secure applications in the cloud with the world's most popular enterprise low-code application platform.

APEX may reside in a local self-managed Oracle database or in a hosted environment (such as an Oracle Cloud service). The sign in process differs depending on where APEX resides.

See Also:

Oracle APEX in Oracle Cloud

Oracle APEX Application Development (APEX Service)

Oracle APEX Application Development (APEX Service) is a low-code application development platform that enables developers to quickly build feature-rich, mission-critical apps that are easy to maintain. APEX uses AI to both accelerate app development and provide a richer experience to app users. Only pay for the resources consumed when an app is used.

Key features include:

  • Includes a specialized Autonomous Database
  • Available Always Free shapes

See Also:

APEX Application Development and What's Included in APEX Service

APEX on Autonomous Database

APEX is installed, enabled, and ready to use in Oracle Autonomous Transaction Processing and Oracle Autonomous Data Warehouse.

Key features include:

  • Includes APEX pre-configured and fully managed
  • Supports a broad ecosystem of Oracle Database clients
  • Available Always Free shapes

See Also:

Autonomous Database.

Oracle Database Cloud Services

There are additional co-managed deployment options for APEX on Oracle Cloud:

  • OCI Base Database Service, Exadata Database Service, and Compute VM
  • Enables full customer control of APEX and its host environment

Parent topic: Welcome to Oracle APEX in Oracle Cloud

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.

Parent topic: Welcome to Oracle APEX in Oracle Cloud

Oracle APEX Web Browser Requirements

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

Parent topic: Welcome to Oracle APEX in Oracle Cloud

What's Included in APEX Service

Learn about the service resources and components included with APEX Service.

  • Service Resources
    Learn about the service resources (that is, maximum ECPUs and storage) included with APEX Service.
  • 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.
  • 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.
  • About the Autonomous Database Included with APEX Service
    APEX Service includes an optimized version of Oracle Autonomous Transaction Processing.

Parent topic: Welcome to Oracle APEX in Oracle Cloud

Service Resources

Learn about the service resources (that is, maximum ECPUs and storage) included with APEX Service.

APEX Service includes the following service resources:

  • Maximum ECPUs - 512

  • Maximum storage - 393216 GB (384 TB)

Note:

Oracle offers two compute models when you create or clone an instance: ECPU and legacy OCPU. To learn more about compute models see Compute Models in Autonomous Database in Using Oracle Autonomous Database Serverless.

Parent topic: What's Included in APEX Service

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

Parent topic: What's Included in APEX Service

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.

See Also:

Oracle REST Data Services

Parent topic: What's Included in APEX Service

About the Autonomous Database Included with APEX Service

APEX Service includes an optimized version of Oracle Autonomous Transaction Processing.

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

See Also:

Autonomous Database Limitations in APEX Service

Parent topic: What's Included in APEX Service