Oracle Application Express (APEX) Review

We can develop everything locally with it but it doesn't talk with other databases

What is our primary use case?

Our primary use case is for human resources. We use it as an application for human resources for the Ministry of Electricity. We also use it for the complaint management system, for collecting the complaints from customers about electricity, and tracking these kinds of requests.

What is most valuable?

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.

Developing based on a web-based application with APEX or another language is more simple and costly.

What needs improvement?

Connecting with Oracle and the relation with Oracle at the database as a procedure needs improvement. 

The front-end development that's looking for HTML, Java, C++, etc also needs improvement. In order to get more out of APEX, there should be more training courses to help beginners start from A to Z. When I started with APEX, I focused on the first part, the relation between database procedure, and later I found I needed more learning courses for the HTML. There should be more training or books looking at the relationship between APEX and Oracle, not between APEX and HTML, CSL, or JavaScript. In order to go more and more with APEX, it needs to start with HTML, CSL, JavaScript, and web development.

The main drawback is that APEX doesn't talk with other databases. It would be great for the tool if you could combine it with different open-source databases. 

For how long have I used the solution?

I have been working with Oracle for around ten years. 

What do I think about the stability of the solution?

It's stable but I experience instability with it when I shifted from version 3.2 to 4.2. There were some errors in the database. I couldn't understand why but after searching I found a solution. But it works now. 

Stability has been for seven or eight years. 

What do I think about the scalability of the solution?

We have three to five developers using this solution.

Which solution did I use previously and why did I switch?

I worked with Java and before Java, Visual Basic from Microsoft. The other person in the Ministry of Electricity is still using Access for Microsoft, Visual Basic, .NET or C#, SQL Server as the database, and PHP. Different people in my company work with different solutions.

How was the initial setup?

The initial setup wasn't easy or complex, it was somewhere in the middle. We deployed it ourselves.

I purchased the database when we started the project with Oracle. I supported the analysis for one year, but after one year we couldn't pay more for the support. We haven't had an issue with maintenance. 

APEX is an open-source platform. I'm busy with the application. It is easy to maintain the application in order to go further with more versions of APEX. It has a different kind of database. Data Point 2.1, is the version that I got from Oracle.

What's my experience with pricing, setup cost, and licensing?

Oracle one of the most expensive databases in the world.

What other advice do I have?

In order to go with APEX, you need to know everything about Oracle as a database, starting from a secure fundamental as the beginning, PL/SQL, and administration of the database. You have to know about HTML5, JavaScript query, and jQuery.

I would rate APEX a seven out of ten. The drawback of APEX is the relation between APEX and Oracle, there is no relation between APEX and other databases. It's very good for learning APEX and it is stable. 

Your company has to understand how to invest in it. It is a wonderful database. If it's Oracle, it is the best one in the world. So when we invest in people, invest in Oracle, we will get our results. Everything is available and everything can be developed with any applications. 

Which deployment model are you using for this solution?

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Oracle Application Express (APEX) reviews from users
...who work at a Government
...who compared it with Microsoft PowerApps
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: July 2021.
523,535 professionals have used our research since 2012.
Add a Comment
ITCS user