Why use Oracle? Because it has Oracle Application Express.
Updated May 17, 2025

Why use Oracle? Because it has Oracle Application Express.

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle APEX

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.
  • 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.
Because it's very easy to develop, fast, secure, has a lot of features. It's like a prototyping tool such as figma, but it can be used as a real product. Dynamic action, plugin, rest api, minimize a lot of coding, a lot of templates, PWA, really bring Oracle APEX functionality to be able to solve most common internal users pain points.
If you are expert in SQL and PLSQL and use Oracle Database, then the best choice is Oracle Application Express. The functionality is already complete and very easy to use, so it's useless to find another tool if you are using Oracle. You don't use Oracle APEX only if: (1) you are using other database than Oracle, and (2) your application load is unpredictable.

Do you think Oracle APEX delivers good value for the price?

Yes

Are you happy with Oracle APEX's feature set?

Yes

Did Oracle APEX live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Oracle APEX go as expected?

Yes

Would you buy Oracle APEX again?

Yes

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.

Oracle APEX Feature Ratings

Low-Code Development
8.0
Drag-and-drop Interfaces
6
Platform Security
9
Platform User Management
8
Reusability
10
Platform Scalability
7

Comments

More Reviews of Oracle APEX

  1. Home
  2. Low-Code Development Platforms
  3. Oracle APEX Reviews
  4. User Review of Oracle APEX