TrustRadius: an HG Insights company

Oracle APEX

Score8.9 out of 10

119 Reviews and Ratings

Get a Demo

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

Key Features

Learn about the best (and worst!) features Oracle APEX has to offer, as determined by TrustRadius' reviewers.
Based on 119 ratings of Oracle APEX's features
View all features

Top Performing Features

  • Reusability

    An internal repository where assets, modules, and even entire applications can be reused

    Category average: 8.6

  • Platform Scalability

    Apps developed by low-code platform must be scalable and capable of supporting large numbers of users

    Category average: 8.6

  • Platform Security

    Security guardrails in place to help prevent malware, data breaches etc.

    Category average: 8.6

Areas for Improvement

  • Drag-and-drop Interfaces

    Drag-and-drop interface for building applications

    Category average: 8.4

  • Platform User Management

    Tools enabling admins to control user access and on-board and off-board users

    Category average: 8.3

  • Visual Modeling

    Visual modeling tooling allows business users to design processes visually.

    Category average: 7.7

Reviews

What users are saying about Oracle APEX.
View all reviews

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

Dominik GrabińskiView 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

Oracle APEX Low code

Incentivized
Prasanta PandaView 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

Oracle apex review.

Incentivized
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

Oracle Apex - Pros and Cons

Incentivized
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

Why use Oracle? Because it has Oracle Application Express.

Incentivized
Verified User
Manager in Information Technology (1001-5000 employees employees)

Use Cases and Deployment Scope

At first, Oracle Application Express was used by only one department. However, after realizing the benefit, gradually it has been adopted by the whole organization. Majority of the use case is for Internal Application, with user mostly from employee. Example of Internal Application such as small-scale ERP, workflow framework, tracking assets and licenses, issue tracking system, and also can be used to analyze and monitor various data, such as activity log and sales dashboard. To use Oracle APEX for commercial application is not recommended, unless you have very good Oracle DBA.

Pros

  • Fast. Nothing beats Oracle Application Express in terms of speed of development. Almost all common and must-have features for most application has been built into Oracle Application Express, and we only need to focus to the business requirements.
  • Quality. Luckily, fast doesn't always translate to low quality. Even using basic wizard, within five minutes, we can build a quality application that has good security, a good user interface and good features, and this can be a very good standard for a company. The default is basic, but it's easy to tweak to achieve higher than standard quality. Notable features are checksum to enable integrity of web application, interactive report, interactive grid, modular ajax functionality, instrumentation for every user and developer action, PWA ready.
  • Customization. The apps created are very customizable. You only need to understand Oracle SQL and PL/SQL, Javascript, CSS3, and JQuery. Then, you can create nearly any application you have in mind.
  • Prototyping. When we are working for a client, sometimes it's hard to be on the same page when at first we only talk about the application concept. Using Oracle Application Express helps to create a prototype application and adjust it according to the client's input within minutes. This greatly helps bringing IT and non-IT clients on the same page faster.

Cons

  • It's tied up to Oracle Database only. If you don't have Oracle Database, forget Oracle Application Express.
  • I wish it has offline mode so it could be used in no-internet areas and sync it when it's back online.
  • It's not critical, but it would be nice if there were more choices of themes. I know Oracle Application Express has couple of themes, but in my opinion, currently only Universal Theme is the theme for Oracle Application Express.

Return on Investment

  • Due to our limited IT resources (mostly because we are not IT company), easy, fast, and sustainable framework allows us to catch up with business improvement without hiring additional IT resources.
  • Prototyping done quickly and easily also improve our application quality. We are able to map business requirements to application more accurately, ensuring sustainability and less maintenance for go-live application. This also saves the need for huge IT resources.
  • Because we already use Oracle Database, and our existing IT members are all proficient in Oracle SQL and PL/SQL, there are only a few learning curves to adopt Oracle Application Express the first time.
  • Because it's too easy and quick, it has downside. We can have tendency to be lazy to adopt other modern and more flexible language.
  • For the business requirement that still changing, this tool is perfect. Any change request will require little effort and can be developed quick.
  • The negative is, if sometimes in future the user of application reaches very big, then we need to rewrite entire application using another technology stack since oracle apex can only scale vertically.

Usability

Alternatives Considered

Appsmith

Other Software Used

Qlik Sense, Microsoft Visual Studio Code, UiPath Automation Platform, Microsoft Teams, Snowflake, OneNote, DBeaver

Related Products

Products similar to Oracle APEX that may also meet your needs.
All comparisons
PostgreSQL
CompareLearn more