Develop and Deploy Apps with Oracle APEX (2024)

Country

MenuMenuContact SalesSign in to Oracle Cloud

Oracle APEX Application Development (APEX Service) is a fully managed, low-code application development platform for building and deploying modern cloud, mobile, and data-driven applications in Oracle Cloud. Business users and application developers can create enterprise applications 20X faster than coding—without having to learn complex web technologies.

Sign up for Oracle Cloud for free

Sign into Oracle Cloud now

Develop and Deploy Apps with Oracle APEX (2)

  • Overview
  • FAQ

Develop and Deploy Apps with Oracle APEX (3)

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.

Find out why

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.

Sign up

Gartner Peer Insights Customers' Choice category distinction

Oracle received the Customers’ Choice rating in the 2022 Gartner® Peer Insights™ “Voice of the Customer”: Enterprise Low-Code Application Platforms for Oracle APEX.

Read more

Build applications 20X faster

Pique Solutions’ time and motion study finds that developers can build applications at least 20X faster with Oracle APEX compared to traditional application development methods.

Read the report

Syneos Health adopts Oracle APEX

The global biopharmaceutical solutions provider taps Oracle APEX to develop its own centralized application for clinical project management.

Read the story

Develop and Deploy Apps with Oracle APEX (4)IDC survey: Organizations worldwide choose APEX

In a recent IDC survey of more than 1,000 organizations worldwide, Oracle APEX was the #1 choice for a low-code application development platform. Oracle APEX was chosen far ahead of all other leading vendors.

Read about the IDC survey

Why choose APEX Service?

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.

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.

Develop and Deploy Apps with Oracle APEX (5)

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

Read the story

Watch the video

View more customer success stories

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

Freedom to build: New Always Free APEX Service available in Oracle Cloud

Oracle Cloud Free Tier provides APEX Service to low-code developers—free for an unlimited time.

Read more

APEX pricing

APEX Service provides everything you need for low-code APEX application development and deployment—all at a low, entry-level price. Simply choose the amount of compute resources (the number of compute resources of Oracle APEX Application Development) and storage resources (the storage resources of Autonomous Transaction Processing—Exadata Storage) that you need. There are no extra costs based on the number of APEX apps, workspaces, developer accounts, or application end users. Data transfer into and out of the service (ingress and egress) is included at no extra cost.

Cost estimator

APEX Application Development

Product

Unit Price

Unit

Oracle APEX Application Development–ECPU

ECPU per hour

Oracle Autonomous Transaction Processing - Exadata Storage for ECPU

Gigabyte storage capacity per month

Oracle Autonomous Database ECPU – FAQ (PDF)

November 30, 2023

Louisiana agency saves hundreds of hours of development effort with Oracle APEX

Karina Pastor, Principal Product Manager, Oracle APEX

Faced with an aging infrastructure and a reduced development team, The Louisiana Administrative Division Office of Technology Services partnered with Oracle to improve the quality of their IT support to many state agencies and groups. Now they use Oracle APEX to provide users with an even faster and more efficient experience. Apps can be developed more quickly, and users spend seconds rather than minutes completing forms.

Read the complete post | Subscribe to the blog

Featured blogs

View all

Resources

Develop and Deploy Apps with Oracle APEX (6)

Access documentation and help center tools

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

Explore APEX Service Documentation


See APEX Service FAQs

Get started with APEX

Start developing now

Develop apps with APEX Service

Start developing now

APEX training

APEX training and certifications

Get started

APEX YouTube channel

Explore APEX solutions

Join us at APEX office hours

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

Find an APEX learning event

Develop and Deploy Apps with Oracle APEX (2024)

FAQs

How to build an app on Oracle APEX? ›

Building Your First APEX App
  1. Create From a File. After signing into your APEX workspace, navigate to App Builder, select Create and choose From a File. ...
  2. Select File. In the Load Data wizard, select the nyc_high_schools. ...
  3. Load Data. ...
  4. Create App Wizard. ...
  5. Name the App. ...
  6. Create Application. ...
  7. Run Application. ...
  8. Explore Application.

What programming language is used in Oracle APEX? ›

The main programming language behind APEX is PL/SQL, although as web applications, you can enhance them with custom HTML, CSS, and JavaScript. Finally, the red oval shapes at the top are your schemas – this is where your data lives and Oracle APEX can access it.

What can you build with Oracle APEX? ›

What can you do with APEX?
  • Build New Cloud and Mobile Apps.
  • Turn Spreadsheets into Apps.
  • Oracle Forms Modernization.
  • SaaS and EBS Extensions.
  • External Data Sharing.
  • Datamart Reporting.

What is Oracle APEX application development? ›

Oracle APEX Application Development (APEX Service) is a feature-scoped and significantly lower-priced workload type of Autonomous Database that enables developers to rapidly build and deploy low-code APEX applications.

What is PWA in Oracle APEX? ›

Progressive Web Apps in APEX

Oracle APEX provides developers with the ability to create Progressive Web Apps (PWAs) that can be easily installed on any desktop or mobile device, offering users a more native app experience.

Can mobile application be developed using Oracle APEX? ›

Oracle APEX Application Development (APEX Service) is a fully managed, low-code application development platform for building and deploying modern cloud, mobile, and data-driven applications in Oracle Cloud.

Is APEX like Java or JavaScript? ›

What is Apex? Apex is an object-oriented programming language present on the Salesforce platform. The language allows programmers to execute and perform transactions to control statements on servers associated with Salesforce. The language uses syntax that is extremely similar to that of Java.

Is APEX similar to Python? ›

So, Apex is basically a programming language like Java, Python, etc.

What are the disadvantages of Oracle APEX? ›

Autonomous Database Limitations in APEX Service
  • No support for Oracle Database clients. ...
  • No ability to store database client connections (SQL*Net) in Connections service.
  • Deployment of the customer managed Oracle REST Data Services is not supported.

What are two main benefits of Oracle APEX? ›

Oracle APEX is unique in that it eliminates complexity at all layers.
  • APEX eliminates mapping between relational and application objects.
  • APEX eliminates remote procedure call complexity.
  • APEX eliminates proliferation of database connections.
  • APEX eliminates middle-tier application logic.

What are two main features of Oracle APEX? ›

Features
  • Data and Reporting.
  • Mobile.
  • User Interface.
  • Security.
  • Accessibility.
  • Monitoring.
  • Globalization.
  • Workflow & Process Automation.

Is Oracle APEX discontinued? ›

It's quite the opposite: APEX is becoming popular in the world of low-code development and, thus, is actively developed and supported by Oracle – which is great news for your software. The current version of Oracle Application Express is 23.2 and it was released in November 2023.

Is learning Oracle APEX worth it? ›

Get to know Oracle APEX – it's worth the effort

APEX is a powerful low-code platform, and nowadays it's much easier to learn than when I started my journey. There's no shortage of sources and tutorials, so be sure to use them to your advantage.

How much do Oracle APEX developers make? ›

The national average salary for a Oracle apex developer is ₹4,40,000 in India.

How to create an application in Oracle? ›

Create an Application
  1. Open the Oracle Application Container Cloud Service Applications page. ...
  2. Click Create Application.
  3. Click an application type: Java SE, Java EE, Node, PHP, Python, Ruby, Go, or . ...
  4. In the Create Application dialog box, complete the fields described in the following table.

How to create an application in Oracle apps? ›

To create an application:
  1. Go to the Process Applications page.
  2. Click Create, and select one of these options: Click Start with a QuickStart to create from a ready-to-use application. ...
  3. Enter information into the Create Application dialog box. Here are a few things to note. ...
  4. Click Create.

How to make an Oracle mobile app? ›

Create a Mobile Application
  1. Sign in to Oracle Application Express by entering the credentials (workspace, username, and password).
  2. On the workspace homepage, click the App Builder icon. ...
  3. Click Create.
  4. Select New Application from the Create an Application window. ...
  5. On the Create an Application page:

How to create template in Oracle APEX? ›

To create a custom template:
  1. On the Workspace home page, click the App Builder icon.
  2. Select the application to which you want to copy the template.
  3. Click Shared Components.
  4. Under User Interface, select Templates.
  5. Click Create.
  6. Select the type of template you want to create and click Next.
  7. Select a creation method:

Top Articles
Latest Posts
Article information

Author: Duane Harber

Last Updated:

Views: 5619

Rating: 4 / 5 (71 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Duane Harber

Birthday: 1999-10-17

Address: Apt. 404 9899 Magnolia Roads, Port Royceville, ID 78186

Phone: +186911129794335

Job: Human Hospitality Planner

Hobby: Listening to music, Orienteering, Knapping, Dance, Mountain biking, Fishing, Pottery

Introduction: My name is Duane Harber, I am a modern, clever, handsome, fair, agreeable, inexpensive, beautiful person who loves writing and wants to share my knowledge and understanding with you.