Try our new research platform with insights from 80,000+ expert users
Oracle Application Express (APEX) Logo

Oracle Application Express (APEX) pros and cons

Vendor: Oracle
4.1 out of 5
Badge Leader
950 followers
Post review

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Oracle Application Express (APEX) enhances rapid development, allowing applications to be built quickly with minimal coding, frequently in a matter of days.
It features powerful integration with Oracle databases, supporting efficient data management and application customization directly within the database framework.
Oracle Application Express (APEX) is beneficial for creating public applications swiftly due to its straightforward deployment capabilities and robust security features.
The architecture of Oracle Application Express (APEX) simplifies translation processes, including support for the XLIFF format to translate applications into a variety of languages, like Arabic.
Oracle Application Express (APEX) supports both SQL and NoSQL, facilitating flexible data handling and application development suited to diverse programming environments.

CONS

Oracle Application Express (APEX) requires better integration with non-Oracle databases and other third-party systems.
The collaboration and workflow engine in Oracle Application Express (APEX) could use significant enhancements.
There are limitations and security concerns with storing passwords in configuration files within Oracle Application Express (APEX).
Exporting dynamic reports is an issue as Oracle Application Express (APEX) only supports static report exports.
There are difficulties in debugging due to how HTML code is generated in Oracle Application Express (APEX), affecting browser compatibility.
 

Oracle Application Express (APEX) Pros review quotes

Mehdi Hasankhan - PeerSpot reviewer
Oct 27, 2019
This product will speed up development time with helpful production aids.
Kamal Deep - PeerSpot reviewer
Apr 13, 2023
The database is super easy to use for creating tables.
reviewer2077248 - PeerSpot reviewer
Feb 13, 2023
I particularly enjoy the web builder capabilities, especially the Page Designer. It offers so many elements or components to choose from, which is a major plus for me.
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
Imtiaz  Ahmad - PeerSpot reviewer
Oct 17, 2022
What I like best about Oracle Application Express (APEX) is that it doesn't require hard coding for reporting and building applications. It's a GUI-based application builder that even end-users with little development and language knowledge can develop applications on Oracle Application Express (APEX). The software is also very user-friendly, which I find valuable.
Abedulrazag Alkhatib - PeerSpot reviewer
Jan 17, 2023
I like that Oracle Application Express (APEX) is powerful and attractive, allowing my organization to modernize forms within two months. I also found its PWA feature very powerful because you can produce substantial mobile applications.
reviewer1404792 - PeerSpot reviewer
Aug 16, 2020
This is a good application for quickly creating public applications.
David Darte - PeerSpot reviewer
Mar 14, 2024
Stability-wise, I rate the solution a ten out of ten.
Ganesh Gurudu - PeerSpot reviewer
Sep 14, 2022
What's most valuable in Oracle Application Express (APEX) is its secure coding functionality, and the solution also has good features.
OA
Nov 29, 2020
One of the most valuable features is that we can develop everything locally and deploy it for different kinds of operators in different locations, so we can do our job in one piece. The benefit of that is that others can use these applications. They connect to the internet to do these kinds of applications based on the permissions for those users.
KR
Aug 8, 2022
One of the most valuable features is the ability to build very fast data-driven UIs.
 

Oracle Application Express (APEX) Cons review quotes

Mehdi Hasankhan - PeerSpot reviewer
Oct 27, 2019
Being able to only design with HTML and CSS can be limiting as to what can be accomplished.
Kamal Deep - PeerSpot reviewer
Apr 13, 2023
Oracle is more of a database-oriented solution and is not very flexible in app development.
reviewer2077248 - PeerSpot reviewer
Feb 13, 2023
Another issue I used to encounter was with the debugging functions. I believe this is an area where Oracle APEX could improve significantly in terms of displaying error messages or error pages. It is very difficult to detect bugs or which bugs you are having when it comes to errors or which errors you have.
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
Imtiaz  Ahmad - PeerSpot reviewer
Oct 17, 2022
An area for improvement in Oracle Application Express (APEX) is the slow reporting because pulling the report for two months, one year, three years, etc., is very slow. It takes more than thirty minutes to download the report. There's also room for improvement in integrating Oracle Application Express (APEX) with other vendors, such as open-source solutions through API integration. I believe Oracle is working on this feature, or the issue could be because my organization is using an older version of Oracle Application Express (APEX). The Oracle database also has to be improved because it's still lacking in some packages, triggers, and indexes.
Abedulrazag Alkhatib - PeerSpot reviewer
Jan 17, 2023
Source control could be stronger in Oracle Application Express (APEX). It needs some work.
reviewer1404792 - PeerSpot reviewer
Aug 16, 2020
There is a problem with security because the applications store passwords in the configuration files.
David Darte - PeerSpot reviewer
Mar 14, 2024
The problem of sending emails arises when Oracle Application Express (APEX) is inside Oracle Cloud Infrastructure since it is a bit complicated or difficult to understand where to take care of the setup part to be able to just send out emails properly.
Ganesh Gurudu - PeerSpot reviewer
Sep 14, 2022
I've experienced some difficulties when using Oracle Application Express (APEX), particularly when I'm designing forms. For example, when I design a form, I add buttons and controls, but I'm unable to visualize how it'll look unless I run it. You want to design and do things your way, but if you don't have much experience, then you'll find that designing in Oracle Application Express (APEX) is a little complicated. This won't be a problem with anyone more experienced, though. If I wanted to create my design, for example, a different table format or some background images, it becomes a problem, and this is an area for improvement in Oracle Application Express (APEX). Designing should be easier, even for less experienced users. An additional feature I'd like to see in Oracle Application Express (APEX) is more plugins, particularly a repository that contains a lot of plugins, so you can go to that repository and download whichever you like and use it or add it to your project. Right now, I create my plugins, so it would be helpful if Oracle Application Express (APEX) has a repository of plugins people can use, download from anywhere in the world, and integrate into projects.
OA
Nov 29, 2020
Connecting with Oracle and the relation with Oracle at the database as a procedure needs improvement.
KR
Aug 8, 2022
I would like to see easier integration into active directory authentication. Also, maybe integration of JavaScript frameworks would resolve some issues.