APEX Application Development

Build apps faster

Create mission-critical applications 20X faster than coding—without having to learn complex AI and web technologies. Leverage a fully managed, low-code application development platform to rapidly build and deploy enterprise-ready, AI-powered apps.

Low-code, AI-powered application development

Build apps using a rich, browser-based, intuitive graphical interface that accelerates application creation. With APEX’s declarative development approach, you can use powerful UI components to add a high level of functionality to apps with limited coding.

Agile development

Iterate to implement changes and make enhancements—often in real time—without the need for complicated, multi-step deployment.

Reliable app responsivity

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.

Built-in security

Help minimize the number of security defects in your apps—from cross-site scripting to SQL injection—with security built into the framework. Reduce time spent configuring security requirements yourself.

Code instrumentation and tracing

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

Oracle Database capabilities at your fingertips

Benefit from the capabilities inherited from Oracle Database, which supports all modern data types including relational, JSON, spatial, and more.

Increase the ease of your AppDev thanks to capabilities like JSON Relational Duality, which allows data stored in relational tables to be accessed as simple JSON documents, or use AI Vector Search to add similarity search to your apps.

Integrate data from both local and remote data sources using REST interfaces.

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

Only pay for resources you consume

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.

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.

AI-assisted AppDev

APEX uses built-in GenAI to simplify application development, reducing your time to build feature-rich, mission-critical applications at scale. Use natural language to generate code and perform one-click debug correction, or kickstart your app creation by using natural language to specify desired capabilities and components—not code.

APEX AI Assistant

Create valid SQL statements by entering a natural language prompt. APEX AI Assistant remembers SQL syntax so you don’t have to, and automates the writing of JOINs. It explains existing code and suggests code bug fixes that can be adopted with a simple click, freeing you from routine coding tasks.

Create App Assistant

Use natural language to specify the desired attributes and capabilities of your new app. Focus energy and resources on creating unique, bespoke application features rather than underlying code.

Conversational AI dialogues

An out-of-the-box conversational interface that you can easily add to your applications, enabling end-users to “converse” with their apps in natural language. Provide a richer in-app experience without the need to build generative AI or natural language processing components from scratch.

Demo: See AI-assisted AppDev in action (3:40)

Enterprise ready

APEX leverages the latest capabilities offered by Oracle Database, making any app developed with APEX enterprise-ready by definition. APEX apps inherit the security, performance, scale, and availability offered by Oracle Database.

Use the latest Oracle Database capabilities to further enrich end-user experience. For example, use APEX in conjunction with AI Vector Search in Oracle Database to combine semantic search for documents, images, and other unstructured data with search on your own private business data.

Demo: See APEX with AI Vector Search in action (2:15)