What is Oracle APEX?

Oracle Application Express

Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere.

Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won’t need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.

Oracle Application Express

Faceted Search

Introducing Faceted Search, a new component that enables you to quickly search and filter your data like never before. Empower your users to see data in new ways, and discover new insights, effortlessly, with just a few clicks.


·         SQL Driven

All of the filtering and computations happen directly in the database, closest to the data.

·         Auto Discovery

Facets are automatically created based on data patterns from your tables.

·         Count Computation

Facet result counts are dynamic and computed based on current filter settings.

·         Multiple Facets

There are a variety of facet types such as checkboxes, ranges, and more.

Oracle Application Express


Oracle APEX offers all the tools you need to be productive, deliver on time, and produce stunning results for your business.

Oracle APEX minimizes the complexity involved with multi-faceted applications and provides developers with the features they need to solve business problems without needing to become experts in vast web technologies. Explore how Oracle APEX helps you build better apps by taking care of these six facets of application development:

  • Data
  • Smart Filters and Search
  • User Interface
  • Security
  • Accessibility
  • Monitoring
  • Globalization

APEX Introduction Video

Why Oracle APEX

Oracle APEX has been designed from the very beginning to help developers build modern, beautiful, responsive applications without the need to become specialized experts.

The mission of Oracle APEX is to empower developers to easily build compelling apps with superior functionality, performance, and end user experience. In order to deliver on this mission, Oracle APEX aims to eliminate the enormous complexities of developing and deploying enterprise apps. Here are a few reasons why choosing Oracle APEX makes sense for your next development project.

  • Eliminating Complexity

Oracle APEX eliminates the complexity of developing and deploying applications at all layers. The result is a low-code platform that is simpler, faster, lighter-weight, and lower-cost than the alternatives. Oracle APEX is unique in that it eliminates complexity at all layers.

Show More

  • Simple Development

Oracle APEX is easy to use and easy to learn. The Application Builder provides a rich, browser-based, intuitive interface which guides you through the creation of your applications. The powerful components of Oracle APEX enable you to add a high-level of functionality to your apps with limited coding. Many customers are productive in a week or less!

  • Powerful and Proven

Oracle APEX can be used to build a wide variety of apps for any industry – from the simplest app that “webifies” a spreadsheet, to mission-critical apps which are used daily by tens of thousands of users. The elegant architecture of Oracle APEX has been used to power thousands of applications around the globe for years.

  • Secure

Oracle APEX is designed to build web apps which are highly secure out of the box. In a world of ever-changing web standards, evolving security standards, and resourceful hackers, the focus on security means that your applications stay protected and remain state-of-the-art.

  • Portable

You can run Oracle APEX everywhere – on the Oracle Cloud, on-premises, or anywhere else there is an Oracle Database. And you can deploy your Oracle APEX applications across any environment with ease.



Oracle APEX Application Development service significantly simplifies the costs typically associated with other low-code platforms. There is no complex pricing associated with the number of users, developers, or apps on your service. There is also no limit to the number of applications that can be developed, the number of developers using the service, or the number of end users using your applications.

  • No Cost Per User

Oracle APEX Application Development service has no per-user pricing, so you can easily deploy applications to any number of users while maintaining a simple predictable cost.

  • No Cost Per Developer

Developing applications using Oracle APEX is easy and does not require an army of developers. But if you have an army of developers, there is no additional cost to put them at your service.

  • No Cost Per Application

There is no extra cost per application you deploy, and there is no limit to the number of applications you create. Unleash your inner APEX developer and cultivate to your heart’s content.

  • No Extra Fees for Data Transfer

There are no additional charges for data transfer (login) or out-of-service (logout) to your service.


  • DBAsfamiliar with PL/SQL can use their skill set to develop web applications
  • Easy to create mock-upsusing pre-built themes
  • Easy to deploy (end user opens a URL to access an APEX application)
  • Scalable(can be deployed to laptops, stand-alone servers, or Oracle RAC installations)
  • Server-side processing and validations
  • Basic support for group development
  • Free hosting of demo applications provided by Oracle
  • APEX applications can run on the free Oracle Express Edition(XE) database
  • Individual components of an application can be retrieved or identified using SQL, facilitating customized reports
  • Easily adheres to the SQA development/test/production model (while not exposing DB passwords)
  • Helps put the focus on the DB model supporting a solution (versus coding in Java, .NET or PHP – you only need JavaScript)
  • Easily supports a standardized theme across application sets (and the changing of that theme)
  • Easily integrates with different datasources such as local database, remote Oracle database, or any web service
  • Semi-technical end users can build their own web pages and reports

Eliminating Complexity

Low-code application development with Oracle APEX is a whole lot more than simply reducing the amount of code necessary to build incredible applications. 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

APEX eliminates complexity of high availability and disaster recovery

While these complexities are often common when developing applications with other platforms, Oracle APEX eliminates the need for this altogether. Simply put, there is no other platform like it.

Low Code - APEX

While APEX has been around in one form or another since 2004, it has recently been included in a new category of application development platforms called Low Code. These Low Code environments can trace their origins to 4GL programming languages and rapid application development (RAD) tools. This progression makes sense, as APEX was originally marketed as a RAD tool. APEX makes it easy to build web applications without the need for code. Where requirements are more complex, APEX allows Low Code objects to be extended via a declarative framework. This framework allows the developer to define custom logic and business rules and create an advanced user interface. The developer does this with SQL , PL/SQL, HTML , JavaScript or CSS and APEX plugins. That’s why APEX allows developers to go from no code to low code to more code.

Oracle APEX is the choice of people from many different job locations

Oracle APEX is the choice of people from many different locations. E.g; students, business users, architects, CIOs…


With Oracle APEX, you can easily build web applications with essentially no knowledge of HTML, CSS or JavaScript. Oracle APEX is tightly integrated with Oracle Database and manages all of the processing associated with data manipulation in a database. If you have a basic understanding of SQL, you can build beautiful, responsive web applications very quickly. For data analysis, Oracle APEX is excellent, as it supports the full SQL language, which is the industry standard for data manipulation and aggregation. If you are familiar with HTML, CSS or JavaScript, you can also exploit your talents in Oracle APEX, to create highly customized UI’s.

Oracle APEX is taught at numerous universities and colleges throughout the world, and demand for employees with Oracle APEX experience is at an all time high and continues to grow. Plus, you can get started for free right now.

Business Users

Oracle APEX includes powerful self-service reporting features. You can easily add custom filters, sort, aggregate, pivot and chart your data, and even create reports which get emailed to you on a periodic basis.

Oracle APEX includes a number of productivity applications which are free and supported – no knowledge of anything is required, not even of Oracle APEX! It’s as simple as installing an app on your smartphone.

Service Request Form

Take Action Now!