Oracle APEX enables you to seamlessly shift apps to and from the Oracle Database Cloud Service, private and public clouds, on premise, and even the free public evaluation service.

Deploy on Premises or in the Cloud

Oracle APEX is unique in that it offers flexibility in where it can be deployed. You can deploy Oracle APEX on premises, on the Oracle Cloud, on a private cloud, or anywhere else Oracle Database runs. Explore some of the most common deployment options and learn how portable Oracle APEX apps are.

Oracle Cloud

All Oracle Database Cloud Services on Oracle Cloud support Oracle APEX. The Autonomous Database Cloud Services, including Always Free Oracle Autonomous Database, provide a fully managed autonomous database with Oracle APEX preconfigured. Customers don't have to bother with database or APEX administration tasks and can concentrate on developing their business applications. Additionally, the Oracle Database Cloud Services on Oracle Cloud Infrastructure are available in flexible configurations, from virtual machines to bare metal to Oracle Engineered Systems.

  • Autonomous Transaction Processing

    Provides market-leading performance with a fully tuned database optimized for transaction processing or mixed workloads.

  • Autonomous Data Warehouse

    Provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance and requires no database administration.

  • Database Cloud Services

    Oracle Database on Oracle Cloud Infrastructure can be deployed in flexible configurations, from virtual machines to high-performance bare metal to Oracle Engineered Systems to run all of your database workloads, large or small.

On Premises or Private Cloud

Oracle APEX makes it easy to turn a database instance into an Application Development Platform within a private cloud. Each tenant gets their own fully isolated workspace in which developers can work independently on their applications.

  • Workspace Provisioning

    APEX Workspaces can be provisioned in automated fashion. When enabled, customers just follow a sign-up wizard. After approval, all provisioning is done automatically.

  • Integrated Resource Management

    APEX makes it easy to integrate with database resource management. As soon as the DBA has created Consumer Groups, APEX workspaces can be easily assigned to them. Applications or Workspaces can be prioritized based on their importance.

  • Integrated Monitoring

    APEX is fully instrumented - administrators can always review activity on workspaces and applications; allowing trends (response times, page views) to be detected and action to be taken if required.

Deploy wherever Oracle Database Runs

Oracle APEX can be deployed anywhere that Oracle Database runs, whether it is running in the Oracle Cloud, on-premises, or a third party cloud, or on Linux, Unix or Windows platforms. This means you can develop an Oracle APEX running on Windows on-premises and deploy it to Oracle APEX running in the cloud on Linux, or vice versa.

Development Lifecycle

Managing any large scale development effort requires an effective framework to enable multiple developers to work concurrently, and the ability to manage the deployment of multiple versions of the application from Development, through QA/Test, and into Production. Learn how Oracle APEX can be integrated with your existing development practices, how to manage deployments across environments, and how to integrate with version control and continuous integration tools for greater control.

Move Applications between Test / Dev / Prod

Oracle APEX contains utilities and features to run on professional Development - Test / Integration / Production platforms.

  • Export / Import

    Use Export / Import to move your application from Development to Test or from Test to Production. All application details are contained in an export file.

  • Command Line

    Export / Import tasks can be fully automated. APEX provides a command-line utility and a PL/SQL API to perform application exports. Importing can simply be done with SQL*Plus.

  • Workflow Integration

    Use operating system or Continuous Integration/Continuous Deployment (CI/CD) jobs to automatically move applications between platforms. Based on command-line export / import, any scenario can be accomplished.

Integrate with version control

APEX is a development platform on a central instance. Developers are working on the same development platform. Integration with version control thus looks different, but can absolutely be done - and is done in practice.

  • Export and Split Applications

    Each application export can be split into individual components. Components are then being checked in to the version control making it easy to detect which component changed when.

  • Automated Version Control Integration

    Use Continuous Integration (CI) jobs to automatically export applications nightly and to check into version control. Developers will get a detailed version history of their application changes without having to do anything. All is done on the central instance.

  • Version Control as Application Archive

    Once application exports are checked into version control, these can also be used as archive, when developers accidentally deleted or messed up their applications. Recovery is done by simply importing back a clean version.