Oracle APEX

Score9.2 out of 10

119 Reviews and Ratings

What is Oracle APEX?

Oracle APEX (or Oracle Application Express) is an online low-code application builder that allows users to develop a database-drive application, customize the application's UI, and then give their users access to the application via URL. Oracle APEX includes a suite of pre-built productivity applications and examples, such as a Survey Builder, Bug Tracking, P-Track project management, etc

Categories & Use Cases

Low-Code Development

Reusability
An internal repository where assets, modules, and even entire applications can be reused
Category average: 8.3
Platform Scalability
Apps developed by low-code platform must be scalable and capable of supporting large numbers of users
Category average: 8.5
Platform Security
Security guardrails in place to help prevent malware, data breaches etc.
Category average: 8.4

Drag-and-drop Interfaces
Drag-and-drop interface for building applications
Category average: 8.2
Platform User Management
Tools enabling admins to control user access and on-board and off-board users
Category average: 8.2
Visual Modeling
Visual modeling tooling allows business users to design processes visually.
Category average: 7.5

#1 most frequent

Professional, Scientific, and Technical Services

24.0%

880 installations of 3,660

#2 most frequent

Manufacturing

13.7%

500 installations of 3,660

#3 most frequent

Finance and Insurance

10.4%

382 installations of 3,660

Dominik Grabiński View profile

Oracle APEX Developer in Research & Development at Pretius (201-500 employees employees)

Use Cases and Deployment Scope

During my over eight-year career as an Oracle APEX Developer, I've developed numerous applications using Oracle APEX technology for various industries, including telecommunications, banking, and pharmaceuticals. The business challenge is usually similar: creating a web application in the shortest possible time. I believe Oracle APEX is an excellent tool for such tasks. Thanks to the many components we can use out-of-the-box, application development is very fast and highly effective.

Pros

Great reporting tool!
Create charts and dashboards in a fun and clear way.
A way to work with flat files like Excel or CSV.
A great connection between the Oracle database and the web-based interpretation of that database in the form of an application.

Cons

Difficult work for offline applications: APEX should maintain a connection to the database at all times.
Harder work with typical mobile applications.
One-page applications. APEX is a typical framework with many smaller pages.

Return on Investment

You can create a web application with basic business requirements in literally 2 hours.
It is very easy to create a PoC of an application for a client in Oracle APEX.
If a client comes with the idea of a mobile application, it is better to consider other technologies.

Usability

Alternatives Considered

Mendix and Power Apps

Other Software Used

Oracle Database, Microsoft Visual Studio, Oracle SQL Developer

Prasanta Panda View profile

Director in Information Technology at Sampoorna Consultancy Pty Ltd (1-10 employees employees)

Use Cases and Deployment Scope

Oracle APEX is our main UI and reporting tool and it is used across the whole organisation. It provides day to day activity tracking and monitoring, providing SLA reporting to top management. Integrated with other internal and external systems using REST services.

Pros

Tightly integrated with the database which help developer to use same knowledge of SQL and PL/SQL to develop the full stack application.
Easy to learn and using low-code we can develop application in no time.

Cons

Improvement on screen layout, specifically designing dashboard with drag and change position and save by user.
Report with sub-reports as drill-down report configuration.
Security across application.
Oracle should develop some plugin and maintain it, like displaying images, start and end date validation plugin, separate time component plugin.
More functionality in IG and standard reports.

Return on Investment

Easy to prototype for new projects.
No additional cost for front end development.
No additional group of developers required as DB developers can use to develop the front end as well.

Usability

Alternatives Considered

Lovable

Other Software Used

Oracle Autonomous Database

Verified User

Consultant in Information Technology (1001-5000 employees employees)

Use Cases and Deployment Scope

Overall, Oracle APEX enables us to: Build scalable, secure applications quickly, improve operational efficiency, enhance data accessibility, and modernize legacy systems without full migration.

Pros

Data-centric apps.
Internal enterprise tools.
Rapid delivery + low maintenance.

Cons

Developer tooling (debugging, version control).
Frontend flexibility.
Modern DevOps integration.
Rapid development.

Return on Investment

High development speed → faster delivery.
Low cost → better budget utilization.
Improved efficiency → measurable productivity gains.

Usability

Verified User

Executive in Information Technology (5001-10,000 employees employees)

Use Cases and Deployment Scope

We are using Oracle Apex for internal development like creating forms or automation of medium complex processes. It is a Power app so provide us both Web app and mobile app features. We are also creating reports in it with good visualization features. But it becomes difficult to develop the program in it, when the process is too mouch complex.

Pros

Creating forms for collecting data from users.
Automating manual process to systems
creating mobile app for existing process.

Cons

It is not fully customizable for a developer
It becomes to develop complex programs in it
The infra of Oracle apex in high in cost.

Return on Investment

License cost of Apex is high.
Infra required for Oracle apex is also high
It creates power app which is compatible on both browser and mobile application

Usability

Alternatives Considered

Liferay Digital Experience Platform (DXP) and OutSystems

Other Software Used

Microsoft Visual Studio, Oracle SQL Developer, Node.js

Amod Joshi View profile

Director Consulting in Information Technology at CGI (10,001+ employees employees)

Use Cases and Deployment Scope

Our organization uses Oracle APEX for below scenarios: Custom Application Development: We use Oracle APEX to create custom web applications tailored to specific business needs. These include HR (Human Resources) management systems as well as Financial applications. Oracle APEX’s low-code environment enables rapid application development without extensive coding expertise, reducing the time required to deliver functional applications. Data Visualization and Reporting: Oracle APEX is being used for building interactive reports and dashboards that provide actionable insights. It allows developers to create graphs, charts, and tables, making it easier for business users to understand and analyze data. Business users are able to visualize business KPIs and other important metrics without needing external tools.

Pros

Data Visualization and Reporting
Process Automation and Workflows
Rapid Application Development with Low Code approach
Integration with Existing Systems
Strong AI Capabilities

Cons

IDCS based Developer accounts
Integration with Fusion Cloud

Return on Investment

Rapid application development and deployment
Less development costs due to low code approach
Scalable and flexible

Usability

Alternatives Considered

Oracle Visual Builder Cloud

Other Software Used

Oracle Visual Builder Cloud, Oracle Fusion Cloud ERP, Oracle Integration (OIC), Oracle Data Integrator (ODI), Oracle Autonomous Data Warehouse

PostgreSQL

Oracle APEX

What is Oracle APEX?

Categories & Use Cases

Oracle APEX Key Features

Top Performing Features

Reusability

Platform Scalability

Platform Security

Areas for Improvement

Drag-and-drop Interfaces

Platform User Management

Visual Modeling

Most Frequent Users

Professional, Scientific, and Technical Services

Manufacturing

Finance and Insurance

Oracle APEX Reviews

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Alternatives Considered

Other Software Used

Oracle APEX Alternatives