TrustRadius: an HG Insights company

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

Top Performing Features

  • 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

Areas for Improvement

  • 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

Oracle APEX - a great tool for creating web applications for Oracle database owners.

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

Oracle APEX Low code

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

Oracle apex review.

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

Oracle Apex - Pros and Cons

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

Best Low Code platform for Rapid Application Development in Oracle world

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