Oracle APEX

This Oracle APEX review covers what the platform is used for, its key features, how Oracle APEX pricing works, where it shines and falls short, and how it compares with other low code platforms. Oracle APEX, short for Oracle Application Express, is a low-code development framework that runs inside Oracle Database. You create an APEX application in a web based IDE with wizards, page designers and property editors. Oracle APEX runs directly in the database, so there is no separate application server tier to install or patch, and storing data, business logic and the app in a single tool keeps the development process simple. Oracle created it in 2004 under the name HTML DB, and it has been part of Oracle Database as a no-cost feature ever since (Wikipedia).

What is Oracle APEX used for?

Oracle APEX is used to build internal, data-heavy business applications on top of Oracle Database. Typical APEX applications are HR systems, inventory and procurement tools, compliance and audit trackers, reporting dashboards, and CRUD apps that replace spreadsheets, Access databases and PDF forms. Many organizations also use it to modernize legacy systems such as Oracle Forms. Harvard University alone runs more than 140 APEX apps and recommends it for reporting and workflow applications, custom business applications and rapid prototyping (Harvard Enterprise Architecture).

The typical builder is a database developer or analyst who knows SQL. APEX developers write SQL queries and PL/SQL for business rules, while the APEX platform generates the pages, navigation, security and user interface around them. Oracle APEX applications range from small departmental tools to mission critical applications, and because they scale with the database, experienced developers can build scalable apps on the same platform.

Key features

• Low code app builder: create an app from a table, a spreadsheet or a prompt, then refine pages in Page Designer. Interactive reports, interactive grids, forms, charts, calendars, maps and faceted search come built in.
• Oracle Database underneath: an APEX app inherits the database's scale, encryption, partitioning and analytics. Data access happens in SQL and PL/SQL, close to the data.
• Security by default: authentication and authorization schemes, session state protection and URL tamper detection. APEX escapes output and uses bind variables to protect against SQL injection and cross site scripting, and access control can go down to row and column level.
• REST and integration: publish RESTful services from database objects through Oracle REST Data Services (ORDS), and consume external APIs through REST Data Sources.
• Universal Theme: a responsive, accessible UI framework with templates, so web based apps work on desktops and mobile devices, including as progressive web apps. Teams can create their own templates on top of the Universal Theme for a consistent look.
• Workflow and automation: approvals, human tasks, workflow definitions and background automations for business processes, with support for email and scheduled jobs.
• AI features: APEX 26.1 adds an AI application generator, AI interactive reports, AI agents and APEXlang, a text language that describes a whole APEX application (Oracle APEX). AI agents can answer questions over your data and act on it, and Oracle presents more AI support for future releases.
• Documentation and support: official documentation, sample apps, hands on labs, the APEX forum and office hours with the product team; paid support comes with your Oracle Database support contract.

Oracle APEX pricing

APEX itself has no license fee. It is a no-cost feature of every Oracle Database edition, and Oracle states there are no per-user or per-application fees, so you can build unlimited applications for unlimited users (Oracle APEX pricing). What you pay for is the database it runs on:

• On-premises Oracle Database: APEX is included in your existing database license.
• Oracle Cloud Infrastructure (OCI): APEX runs on Autonomous Database or the APEX Application Development service, a managed, scalable service billed by compute and storage.
• Always Free: OCI's Always Free tier includes Autonomous Database instances with APEX, enough to learn the platform and host small apps.
• Free workspace: apex.oracle.com offers free workspaces for learning and prototyping, not for production data.

Oracle Cloud Infrastructure also offers resources such as backups, scaling and monitoring for the database behind your apps.

The cost surprise to check is the database licence. APEX is free only if you already run Oracle Database or accept Oracle Cloud; for a team without Oracle, the database or cloud bill is the real cost of the app. Check the Oracle Cloud price list for your region and compute size before you plan a deployment.

Security and access control in Oracle APEX

Security is where APEX differs most from other low code platforms. An APEX application runs inside Oracle Database, so data access never leaves the database tier and it inherits the database's encryption, auditing and data protection. User management works through built-in authentication schemes or single sign-on, and authorization schemes control access to pages, regions, buttons and processes. Row and column level access control comes from the database itself, so security rules apply to every user and every app that reads the same data. Security updates for APEX ship with regular releases and are applied for you on Oracle Cloud. APEX also protects against SQL injection and cross site scripting by design, which makes it a common choice for enterprise grade internal apps that handle personal or financial data (Datavail).

Oracle APEX development: skills and learning curve

Oracle APEX is easy to learn for anyone who already knows SQL. Simple reports and forms take hours, and the wizards, sample apps and hands on labs shorten the start. Complex apps take longer, because business logic lives in PL/SQL and good performance depends on a good data model. People without database experience find the learning curve steeper than in visual app builders. Harvard advises teams to create the data model first, agree coding practices and templates, build reusable components, use logging and debugging, and run production in runtime-only mode, with version control and a consistent development life cycle from the start.

APEX developers stay in demand in organizations that run Oracle Database, especially for Oracle Forms modernization and internal tools. The role sits between a database developer and a software engineer: development happens in the browser, but good APEX work still needs SQL, PL/SQL and some JavaScript and CSS for custom user interface work. Compared with other platforms, the support resources are strong: official documentation, a large community of APEX developers, and Oracle's own training.

Oracle APEX vs Salesforce Apex

The names are the only thing they share. Oracle APEX is a low-code platform for building web apps on Oracle Database. Salesforce Apex is a programming language for writing custom logic on the Salesforce platform. A search for "APEX developer" can mean either role, so check the job description.

Where Oracle APEX shines — and where it falls short

Strengths:

• No license fee on top of Oracle Database and no per-user pricing.
• Fast delivery of secure, data-driven internal apps and reporting dashboards.
• Enterprise grade security and scale inherited from the database.
• Strong fit for modernizing Oracle Forms and spreadsheet processes.

Trade-offs:

• Tied to Oracle Database; teams on other platforms or databases need a different tool.
• Needs SQL and PL/SQL for anything beyond simple apps.
• Less suited to highly customized consumer-facing apps or single-page front ends.
• A smaller talent pool than general web frameworks outside the Oracle world.

How Oracle APEX compares

• Mendix: enterprise low-code with visual logic and broad database support.
• OutSystems: enterprise low-code for large, customer-facing and internal apps.
• Microsoft Power Apps: the Microsoft 365 and Dataverse equivalent.
• Retool and Appsmith: internal tools on top of any database or API.
• Quickbase and Caspio: no-code database apps without running your own database.
• Claris FileMaker: desktop-first database apps for small teams.

Is Oracle APEX worth it?

Oracle APEX is worth it for organizations that already run Oracle Database: the platform costs nothing extra, delivers secure internal apps quickly and scales with the database. It is the natural path for Oracle Forms modernization and for replacing spreadsheet processes with real applications. It is less of a fit for teams without Oracle, for teams without SQL skills, or for consumer apps where front-end design matters most. If you need help to build or modernize an APEX application, low-code agencies and developers on LowCodeDevs can take it on.

Sources

• Oracle APEX: product overview, APEX 26.1 AI features and APEXlang.
• Oracle APEX pricing: no-cost feature of Oracle Database, deployment options.
• Using Oracle APEX, Harvard Enterprise Architecture: use cases, best practices and where APEX is not a good fit.
• What is Oracle APEX?, Datavail: architecture, security and REST integration (an Oracle services partner).
• Oracle APEX low-code development, EffectiveSoft: capabilities and use cases (a development agency).
• Oracle Application Express, Wikipedia: history since 2004.