APEX Application Development

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.

Introduction to enterprise low-code apps using Oracle APEX (1:40)

APEX 24.1 Brings GenAI to Developers

The APEX 24.1 release uses GenAI to make life easier for app developers and app users. Learn how it helps developers create even better mission-critical enterprise apps that users will love, in less time.

APEX wins InfoWorld’s 2023 Technology of the Year Award

InfoWorld recognized Oracle APEX as the year’s best in the category of Software Development: Platforms.

Join us at ODTUG Kscope24!

See APEX 24.1 in action, and exchange best practices with like-minded developers and business leaders from around the world at the annual APEX Conference at ODTUG Kscope24 from July 14 – 18 in Nashville, TN.

Webcast series: Business Innovations with Oracle APEX

Watch our monthly webcast, which spotlights customers from around the globe who are building innovative, low-code apps with Oracle APEX. Find out how they are solving their business problems.

Build applications 20X faster

Pique Solutions’ time and motion study finds that developers can build applications at least 20X faster with Oracle APEX.

APEX can retrieve desired data in the most efficient way possible, because the AI function in APEX has direct access to all metadata in the database and can perform more complex queries and generate more accurate results than would be possible manually, even by an expert.

Carl Olofson, Research Vice President, Data Management Software, IDC

“Fourth-generation languages (4GLs) and low code development tools have been around for decades, and many are tied to a database. For the most part, however, they stand outside the database, interacting as an external client. Oracle APEX resides inside the database system, which enables zero latency between application and data, while leveraging all the salient features of Oracle Database. But what really makes it stand out is that it generates not code but control blocks in the database system, so that the application is built declaratively rather than procedurally. This means it is always self-documenting because its operations are tied to elements of the database.



With this newest version, APEX is thoroughly integrated with an AI-driven natural language processing (NLP) capability that enables not only the creation of data operations and views in response to ordinary human language requests, but optimized navigation through the database, the kind formerly available only through a database expert. APEX can retrieve desired data in the most efficient way possible, because the AI function in APEX has direct access to all metadata in the database and can perform more complex queries and generate more accurate results than would be possible manually, even by an expert. APEX also integrates AI Vector Search or JSON Relational Duality Views into applications. Thus, APEX opens up a wide range of both structured and unstructured data for complete and intelligent, detailed access even by non-technical users.”


Carl Olofson Research Vice President, Data Management Software, IDC

Why choose APEX for low-code AppDev?

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)


Hilton-logo

NRI reduces application development efforts by 65% with Oracle APEX

"Oracle APEX has become a critical driver of the value we provide to our customers. It allows us to both reduce costs and develop applications faster."

Shota Isshiki, bit.Labs System Architect, NRI

APEX Service use cases

  • Cloud and mobile apps

    Build new cloud and mobile apps for a diverse range of use cases—with minimal effort.

    Oracle APEX mobile features

  • Data-driven apps

    Get a handle on rapidly expanding data with powerful, built-in charts and data visualizations.

  • Spreadsheet replacement

    Transform spreadsheets into fully functioning apps with autogenerated reports and data entry forms.

  • SaaS and packaged app extensions

    Get more from SaaS and packaged apps by filling in feature gaps and adding highly customized reports.

  • Forms modernization

    Upgrade and modernize existing Oracle Forms apps. Substitute for a contemporary, browser-based, and mobile-friendly UI.

  • Public SaaS and ISV apps

    Besides being a great solution for apps that meet internal business needs, APEX Service also can be a platform for public SaaS apps, and it can help independent software vendors (ISVs) deliver such apps. No Oracle Partner Network membership is required.

    Learn more about Oracle APEX use cases

June 17, 2024

Announcing Oracle APEX 24.1 General Availability

Ashish Mohindroo, Vice President, Product Management APEX Low Code Application Platform

Oracle APEX 24.1 is now generally available for download and is being rolled out to OCI APEX Application Development and Autonomous Database Cloud Service regions across the globe. Learn how to build your first low-code app with GenAI with this latest release.

Featured blogs

View all

Resources

Learning

Access documentation and help center tools

Help Center provides detailed information about services, getting started guides, and content for workshops


Get started with APEX


Start developing now

Develop apps with APEX Service


APEX training

APEX training and certifications


APEX YouTube channel

Explore APEX solutions


Join us at APEX office hours

Join APEX developers and product mangers for training and how-to sessions