APEX Application Development

Rapid application development

Low-code development

A guided approach with a rich, browser-based, intuitive graphical interface accelerates application creation. Powerful UI components enable users to add a high level of functionality to apps with limited coding.

Absolutely responsive

Applications built with APEX are fully responsive. Components such as forms, charts, and reports work seamlessly across varying screen resolutions while maintaining the same functionality without any additional code.

Agile development

Developers can iterate to implement changes and make enhancements—often in real time—without the need for complicated, multistep deployment.

Build apps with confidence

Minimize the number of security defects in your apps—from cross-site scripting to SQL injection—with security built into the framework.

Code instrumentation and tracing

Detailed diagnostic data can help developers find defects or performance issues in applications early in the development cycle.

Future-proof apps with a converged database

Build modern, data-driven applications using a converged database, which supports all modern data types including relational, JSON, spatial, and more. Integrate data from both local and remote data sources using REST interfaces.

• ESG Blog: Oracle's APEX enhancements and Database 21c release continue progress on its magnum opus

Autonomous operations

Automated management

Replaces error-prone manual operations with machine-learning–driven automation to provision, scale, secure, back up, and repair the entire application stack.

Consistent high performance

Delivers consistent, high performance with a unique in-database application architecture, automated database tuning, and indexing capabilities of Autonomous Database and purpose-built Exadata hardware.

Streamlined architecture

Increases developer productivity, scalability, and performance of applications due to a highly streamlined architecture. Automatically manages session state, resolves application logic, and manipulates data directly in the database with nearly zero latency data access.

Auto scaling

Scales compute resources automatically to meet throughput requirements—without any downtime—even as data volume and the number of users grows.

Always online

Provides high availability using a combination of Oracle’s Gen 2 Cloud Infrastructure, Oracle RAC, and daily automatic backups.

Easy administration

Easy-to-use management through the Oracle Cloud Infrastructure console, public REST APIs, and Software Development Kits (SDKs) allows users to perform the most common tasks such as setting up governance and analyzing usage/billing.

Lower costs

Pay-per-use subscription model

Optimize innovation and cost savings by matching cloud resources to your changing business needs with online elastic scaling. Only pay for the resources you consume with a true pay-per-use experience.

All-inclusive pricing—no per application, per user fees

Build applications without limitations. Unlike other low-code platform cloud providers, there are no hidden or additional usage fees per application, developer, or end user.

Free version you can use for an unlimited time

A small Always Free version of APEX Service in Oracle Cloud Free Tier makes it easy to get familiar with the service at no cost. If applications evolve to require additional power, then a single click upgrades free APEX Service in-place to the full paid version, where you can elastically augment compute and storage resources.

Powerful data visualization

Faceted Search

Faceted Search enables users to quickly search and filter data. Empower users to see data in new ways and discover fresh insights with just a few clicks.

Dynamic charts

Powerful chart and visualization capabilities are fully HTML5 capable and work on any modern browser. Oracle JET provides a modular, open source charting toolkit for developers.

Interactive reports

The interactive report component enables users to effortlessly customize the data they see in a way that uniquely satisfies their needs, all with zero coding.

Cards components

Unlock a powerful new way to present data using cards. The cards component provides easy customization of appearance including icons, badges, media, advanced HTML expressions, and the ability to define multiple actions per card.

Transform spreadsheets

Spreadsheet to web app—in minutes

With just a few clicks, transform a spreadsheet into a fully functional app with customizable dashboards, charts, reports, and forms. Easily access and maintain your data from a web app.

Enforce data integrity and accuracy

Eliminate spreadsheet sprawl and data inaccuracy with apps that can be accessed from a single, centralized location for a single source of truth.

Enable authentication and authorization

Protect your apps with SSO, OAuth2, OpenID Connect, and more. Give apps the security most spreadsheets lack.

Prebuilt productivity apps

Ready-to-use apps

More than 20 fully functional, ready-to-use productivity apps for important and prevalent business scenarios.

Extendable apps

Extend and customize prebuilt apps to meet your business needs. Easily adapt these apps to unique requirements.

REST data access

Consume web services

Access data from diverse web services, including Oracle SaaS application REST endpoints, and manipulate results using SQL.

Provide REST APIs

Quickly build web services that access Oracle Database objects using the built-in REST workshop, then generate Swagger API documentation with a single click.

Globalization and localization

Translation

Translate running application UI into multiple languages without having to duplicate logic or repackage your apps.

Localization

Easily format and display application content based on the end user's current location.