Oracle APEX Reviews and Ratings

Rating: 8.5 out of 10

Score

8.5 out of 10

Community insights

TrustRadius Insights for Oracle APEX are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Development Speed: Users have praised Oracle Application Express for its rapid development capabilities, allowing them to focus on specific requirements while quickly creating applications. The platform excels in speed and includes common features required for most applications.

Customization Options: Reviewers appreciate the extensive customization options in Oracle Application Express, requiring knowledge of various technologies like Oracle SQL, PL/SQL, Javascript, and JQuery to create a wide range of applications with personalized functionalities.

Ease of Use: Customers highlight the ease of use, configuration, report building capabilities of Oracle Application Express. They mention its user-friendly UI providing a variety of templates for designing screens and enabling the creation of basic CRUD screens without detailed technical knowledge, making it accessible for users with varying levels of expertise.

Reviews

41 Reviews

Best Low Code platform for Rapid Application Development in Oracle world

Rating: 10 out of 10

March 17, 2025

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

Likelihood to Recommend

Based on our organization's experience, Oracle APEX is a versatile and powerful tool, but its suitability depends on specific business needs, technical requirements, and the nature of the application being developed. Scenarios where Oracle APEX fits well: Business Process Automation/Workflows Reporting and Dashboards for Data Analytics AI based systems such as Select AI Chatbots for data insights based on LLMs Native-like Mobile Applications using PWA feature of APEX Scenarios where Oracle APEX may be less appropriate: Very Complex and highly interactive applications Use cases based on a non-oracle Database

Amod Joshi

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

Vetted Review

12 years of experience

View profile

Oracle Apex - Pros and Cons

Rating: 9 out of 10

Incentivized

December 18, 2024

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.

Likelihood to Recommend

It is well suited where we have to create forms in which user enters data and it will go to decided authority for maintaing data.

It is not well suited where we have to convert whole manual work to system in which lot of logics complex logics and difficult to maintain that program.

Verified User

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

Vetted Review

2 years of experience

Best Low Code Application Development Platform

Rating: 9 out of 10

Incentivized

January 5, 2024

Use Cases and Deployment Scope

My Organization used Oracle Application Express for many custom applications, few are open on Internet. These applications cover areas like ERP security, ERP related complex reports, Dashboards, Manufacturing related, etc. Our apps are integrated with ERP, Cloud based CRMs, many licensing applications, etc.

Pros

Reporting
Dashboards
Various Data forms
Quick applications
Consuming REST Data Services

Cons

Workflows - flexible one, with option to approvals by emails
In-built connector for Microsoft Outlook 365 Cloud and world's most used emailing / Active Directory applications

Likelihood to Recommend

Very fast database level applications

Applications where reports and forms are there

Getting data from various sources like cloud

Verified User

Project Manager in Information Technology (1001-5000 employees)

Vetted Review

5 years of experience

Business Intelligence in Oracle APEX

Rating: 10 out of 10

September 15, 2021

Use Cases and Deployment Scope

<div>Currently we use Oracle Application Express in only one department, but looking at how easy and fast is to add more small apps solving different tasks I believe it will be broadly adopted by a large audience very shortly.

I want to share my experience in one app we did. We are maintaining a relatively large data warehouse, design in star schema. This was used as a source for few BI tools and standard reports presenting some parts of Data Warehouse, but there was always a need for people with no SQL knowledge to get look in some part of data warehouse not presented in existing reports and tools to explore new possibilities or just to verify data. So we need some kind of simple presentation layer that quickly and easily can expose the data model and provide access to end user where they can review data in form of tables or charts. APEX look like is the perfect environment for that. </div><div>Missing bit in APEX is built in functionality to define data model but that was easily solved by simple web forms where power user can define relations between fact and dimensions and store that metadata to enable dynamically SQL generation later by end users. The end users can generate dataset automatically using simple graphical interface, without the need to know SQL. Data presentation is power by a dynamically populated APEX interactive data grid. It appears that the solution was adopted by users well and we enriched it quite easily with adding functionality to organize access to app by user, roles and different permissions enabling user to share report definitions between them. This is app working internally but I created an instance of it in OCI where you can see how it works presenting a sample oracle star schema model.

<a title="Link: https://simplebimple.com/" href="https://simplebimple.com" target="_blank" rel="nofollownoopener">https://simplebimple.com</a>

user: demo

pass: demo

</div>

Pros

Easily create web application
Rich , ready to use web interface components
Easy deploy and maintain application
Simple and powerful security configuration out of the box

Cons

Some of the configuration options are a bit hidden, probably a bit better organization of workspace and application settings would benefit development process

Likelihood to Recommend

APEX is very well fit for solving fast some day to day activities in every organization.

Verified User

Consultant in Sales (5001-10,000 employees)

Vetted Review

3 years of experience

Why use Oracle? Because it has Oracle Application Express.

Rating: 10 out of 10

Incentivized

April 13, 2021

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.

Likelihood to Recommend

The most suitable case for Oracle Application Express is any application, web desktop or mobile used by internal employee, that only needs to store and manipulate data in Oracle Database, and be accessed online all the time. If you don't use Oracle database, forget about Oracle Application Express. To use Oracle Application Express for wider user base is not impossible, but you will need to tweak the configuration and need a very good DBA to make sure that the potential load is manageable. And since all the business logic will be inside the database, you can only scale up vertically.

Verified User

Manager in Information Technology (1001-5000 employees)

Vetted Review

12 years of experience

Oracle Application Express is good for fast applications and reports development

Rating: 10 out of 10

Incentivized

November 21, 2019

Use Cases and Deployment Scope

Oracle Application Express is being used by IT engineers. They build reports and small applications for our users in other departments, especially the marketing and financial departments.

Pros

Easy to use.
Easy to configure.
Easy for building reports.
Easy for building forms.

Likelihood to Recommend

Oracle Application Express is good for easy and fast application and reports development. You can develop entire applications and you do not need another web server. However, you cannot access the source code of applications built in Oracle Application Express.

Verified User

Director in Information Technology (501-1000 employees)

Vetted Review

2 years of experience

Quick development and deployment for simple apps!

Rating: 9 out of 10

Incentivized

November 13, 2019

Use Cases and Deployment Scope

Right now I created a small app to track pending/ongoing tasks using APEX on the newly available Oracle Cloud Free Tier. I decided to create it to simplify how I manage and execute my daily tasks in order to be able to both track advance and manage dependencies between tasks. I use Trello to keep boards with simple tasks but managing dependencies was something not simple to achieve, so I decided to try a solution that solved my problems while starting to use APEX.

Pros

The UI is very easy to use, and you can choose from a number of templates for each "screen" you design.
You can design basic CRUD screens without knowing the "details" (technology) under the hood.
It's easy to test. Just one click, and the page you are working on is executed.

Cons

Deployment on an OnPremise DB is not so simple. You need to follow many steps (that's why I used the Cloud version!).

Likelihood to Recommend

I would definitively use APEX for small (department size) applications that can be developed and maintained by a small development team, without a complex design/develop/test/deploy process.

Also, to generate all basic CRUD on complex applications, rather than programming them using other languages (Java. c#, etc) and having more complex deployment processes.

Lisandro Fernigrini

Sr. Software Developer / DBA in Information Technology at Kapsch Group (1-10 employees)

Vetted Review

2 years of experience

View profile

Fast, cheap, and easy application development

Rating: 10 out of 10

Incentivized

October 14, 2019

Use Cases and Deployment Scope

First of all, it's very easy to use and within hours I can have an application made. I like that the interface is useable and easy to navigate. I also liked that there is a lot of configuration possibilities. I found a lot of plugins available for it, so it makes our development much easier.

Pros

Easy set-up.
Plugins.
Lot of configurable options.

Cons

Hard to use version control.

Likelihood to Recommend

If you need rapid application development, this is the tool that you need. It is easy to use, and you can develop an application easily and fast. But they should really improve the version control, sometimes its hard to use.

Verified User

Employee in Engineering (51-200 employees)

Vetted Review

2 years of experience

Awesome APEX

Rating: 10 out of 10

Incentivized

September 18, 2019

Use Cases and Deployment Scope

APEX is being used by our Financial department as well as HR supporting a variety of applications. It is a wonderful tool supporting a variety of interfaces.

Pros

Very rapid development of forms and reports.
Awesome GUI look and feel.
HTML 5 and CSS 3 compliant. The new version 19.2 now supports rest endpoints for forms and reports.

Cons

Integration with other databases like My SQL, etc.

Likelihood to Recommend

Very well suited for medium enterprise applications.

Verified User

Former Employee in Information Technology (10,001+ employees)

Vetted Review

10 years of experience

Snap! The future is here

Rating: 10 out of 10

Incentivized

August 30, 2019

Use Cases and Deployment Scope

Oracle Application Express serves as a prime web and mobile application builder for our organisation. It is used internally to serve apps that we use on a daily basis and also build apps for clients. It has provided much needed security and a fast way to build apps by just focusing on the data, taking and presentation of that data to the client while still being fully integrated on the oracle platform with easy access to database and services.

Pros

Manages security well
Provides a responsive environment to build apps in
Easy connection to database services
Manages sessions very well

Cons

Javascript functionality
Mobile app development- more versatility required especially with the display of reports
More documentation that is easy to understand
More sample apps on configuration of services and authentication schemes
Make it easy to customize templates
More themes required

Likelihood to Recommend

Best for web applications. Less appropriate, however, for mobile applications. Applications that deal with businesses are quite useful.

Verified User

Technician in Information Technology (11-50 employees)

Vetted Review

1 year of experience

Loading Reviews List....

Home
,
Low-Code Development
,
Oracle APEX
,
Reviews and Ratings

Why use Oracle? Because it has Oracle Application Express.

Rating: 10 out of 10

Incentivized

April 13, 2021

Use Cases and Deployment Scope

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.

Likelihood to Recommend

Verified User

Manager in Information Technology (1001-5000 employees)

Vetted Review

12 years of experience