Oracle Application Express (APEX) Reviews

We develop software for local governments as well as software licensing.

We look after the local government and Healthcare.

A user interface is relatively simple to create.

I can easily connect to the servers. It has a fast connection.

Making a CI/CD lane for it is a bit difficult.

It is difficult to achieve continuous delivery or continuous integration.

Stability and technical support could be enhanced.

It would be beneficial to include WebSockets so that you can see real-time updates.

I have been working with Oracle Application Express (APEX) for three years.

We are not using the most recent version, but we are close.

Oracle Application Express (APEX) is not very stable.

Oracle Application Express (APEX) is a scalable product.

This solution is used by ten developers or technical consultants in our company.

We may increase our usage in the future.

I had a technical issue, and it took me a month to get an answer from Oracle.

Response time is very slow.

I work with multiple solutions simultaneously.

We have people who surf the servers on our behalf. They are simply regular Windows computers, but not in our location, but in another. Similar to a cloud.

We have several small cloud providers. They are based in the Netherlands.

It is rather complex to install.

I would rate the installation a three out of five.

It took approximately, one day to deploy.

We need two developers to maintain this solution.

Our in-house team completed the deployment.

I believe it is free, but the Oracle database license must be purchased.

It is expensive, but I don't know what the licensing cost is.

I did not consider alternative solutions. This solution was already chosen and in place when I started at this company.

It all depends on the solutions you seek. But, yes, I would probably recommend this solution to others.

I would rate Oracle Application Express (APEX) a six out of ten. The idea of the product is good, but there are issues that make it difficult to work with.

Oracle Application Express (APEX) can be used for anything which requires quick creation of a user interface with user interaction with a database. Sometimes it's used more for reporting, but in many cases, it's for interactive reporting or interactions with the tool to record dates in the database. For example, it can be used for internal use within the company for the testing team to conveniently add test cases. Additionally, it can be used for comprehensive reporting for the financial teams, they can perform some work related to revenue recognition. 

I didn't work with big projects exposed to the public, the use cases were mostly internal platform projects.

The most valuable features of Oracle Application Express (APEX) are the ease and speed of development. Instead of engaging a large team of middleware, front-end, and database engineers, we can have professional look at the front end and have the user interface up and running in a matter of days. However, if you want to go far and implement very custom features, it doesn't require a lot of knowledge of front-end development, such as HTML, JavaScript, or other aspects.

I have been using Oracle Application Express (APEX) for approximately 10 years.

The stability of Oracle Application Express (APEX) is 100 percent. It is highly stable.

Oracle Application Express (APEX) is highly scalable and can serve up to a required number of users. However, I do not have experience with serving more than approximately100 users. I'm always advertising this tool as being scalable. Bring in the shop.oracle.com as an example, because that site is running on Oracle Application Express (APEX), and you can imagine it can serve up to an unlimited number of users. With good hardware behind the solution, it's scalable, but since I don't have direct experience, I'm pretty sure it's scalable to any possible level. My confidence level in that is 90 percent scalable.

I have not had the need to contact technical support because of the number of resources and amount of information available with only a couple of mouse clicks, such as documentation, Q&A, and FAQ, they have a lot of material available. I know that browsing those websites people sometimes face some issues with not having their issue resolved, but this has not been my experience.

Oracle Application Express (APEX) comes with Oracle. The Oracle price itself. I do not know the exact cost. Oracle is flexible on its price. If you overspend on your hardware, then I don't think you will overpay. I heard that Oracle is more expensive than other databases, but when you consider Oracle is the best traditional relational database out there. You get what you pay for.

I rate Oracle Application Express (APEX) a nine out of ten.

Our business applications include healthcare, administrative, and planning tools. The environment consists of on-premise databases with an Oracle ORDS Tomcat stack and other JavaScript utilities on top of Linux Virtual Machines. There are legacy solutions, such as Oracle 11 with APEX 5.1 and Oracle 19 with APEX 20. These solutions have proven to be quite stable, but you need to do proper planning and profiling of heavy database transactions for more significant queries and heavy transaction processing.

Oracle APEX has proven to be a solid "low-code" solution that works quite well for simple and complex scenarios of data-intensive applications. Integrating the tool with the robust underlying Oracle Database allows a team to quickly create and deploy functionality iteratively. Running the tool on top of Linux-based virtual machines can slow things down, but the work gets done, and using the Oracle XE editions for some clients has been an adequate solution for POCs or even small non-critical production apps.

Oracle APEX's reporting features are simple yet powerful. The ability to quickly create CRUD screens has simplified many RAD discovery processes, while the APEX environment allows the product owners and dev teams to quickly understand the complex solutions and employ usage statistics to identify areas requiring improvement. The option to add external JavaScript tools in screen development enables the development of complicated mobile or web usage scenarios in rare cases where the APEX UX  is not enough.

Oracle should implement vertical and horizontal data segmentation in APEX's security framework, so Dev teams don't need to do any heavy lifting in the APEX screens. This is a common issue in enterprise apps. It would be nice to seamlessly integrate Git repositories into the development process since the current solution can result in overlapping work or an eventual overwrite. The provided example apps are great, but they could benefit from some added documentation in the "explanation screens".

I've been using Oracle APEX since 2006.

Oracle Apex is stable.

Oracle Apex scales well, but you need a good admin who knows how to work with DBA and Linux.

Oracle support has room for improvement.

Neutral

Setting up APEX requires Oracle and Linux admin experience.

We implemented APEX with an in-house team.

APEX is free, but Oracle Database is not.

I rate Oracle APEX eight out of 10. It's a good tool that needs more promotion, particularly the cloud solution.

We use this solution for reports, data queries and as our CMS. APEX is our purchase requisition system. We are customers of Oracle, I'm the facility director and a user of APEX. 

The solution is fairly intuitive and has a user-friendly UI. The great thing is that in terms of process mapping, it's already configured including for drag and drop and easy manipulation of objects.

It would be helpful if the solution was in a format recognized by Microsoft Word products. 

I've been using this solution for five years. 

The solution is stable. We have an engineer who deals with the maintenance. 

The solution is scalable. We might increase the number of users but for now we only have 20 users. 

The deployment was easy and took no time. 

This solution is free for us because we use an Oracle-based product for our purchasing and it's included in that. 

I rate this solution seven out of 10. 

I have it installed in my computer, and I'm trying to build some GL applications for independent consulting just to track expenses. 

APEX is putting a lot of money into the new versions and giving new features to people like coding and building applications. I believe they're on version 21 now. I worked on their product a lot, and I did a mini project to implement Oracle applications. I have done many projects in three continents, like Africa, Europe, and now in North America.

You don't have to know a lot of PL because it's built on PL/SQL. You don't need developers. You only need to design a good application that resolves a problem, or many problems, for companies and you're ready to go. When you design it, you just need to understand how the tools work, and it's almost drag and drop. APEX does all of the coding in the backend. You don't have to know how to code PL/SQL or CSS or HTML.

A lot of times I ask my clients why they don't use APEX. They have the Oracle database and it's free, so why don't they use it to build this application? They go to Grails or inside development with many developers. I never understood why they couldn't just use APEX to build their own applications. The solution is free, and you're building something inside the house and you have the people that can design your application. They use other technologies on top of Oracle.

Maybe some people go with other technologies because they are more familiar with them. Oracle probably needs more communication about APEX and to show people that they have something free on their hands and that they need to give it a chance.

Maybe there are other technologies that offer what APEX cannot. Oracle is working hard on APEX to put it more on the cloud, so it is more useful for people that know how to code.

APEX is a stable solution.

I don't see it as complex, but not many people have that kind of skill.

The solution is free.

I would rate this solution 7 out of 10. 

The only advice I can give is to just try it and give it a chance.

We are using one application developed in APEX for COVID information control, and all our employees are reporting the symptoms.

Oracle Application Express is easy to use, people don't have to be developers to use it.

Some of the application interfaces of Oracle Application Express are not very attractive and could be improved.

I have been using Oracle Application Express for approximately two years.

Oracle Application Express is highly scalable. We are running it on Oracle RAC with a 60-terabyte database and we dedicate one schema for the user databases. In the database, we are running Oracle Business Suite and APEX, it is running very well.

We have approximately 1,000 people using this solution in my organization. Many of them are analysts and business users.

We plan to increase the usage of the solution.

The technical support has been good.

We previously were using Java deployments, but it was difficult to maintain standards for the applications. We are using, access development desktop databases. Every department used different people for the applications and different standards.

The installation is simple and the time it took was approximately two weeks.

I did the implementation of the solution myself.

We have approximately three technicians and two engineers that do the maintenance of the solution.

We have an Oracle basic product license, and then we can use Oracle APEX for free. We have many licenses for Oracle for approximately 20 processors.

We have evaluated other options before choosing Oracle Application Express.

Oracle Application Express it's a very good solution for many use cases. It can be deployed rapidly and I highly recommend it for the replacement of users' databases, such as Access.

I rate Oracle Application Express a nine out of ten.

We have several projects with 200 to 300 users. 

It is used by developers, building applications for people who want to track things in spreadsheets.

The most valuable part of this solution is the database design features. We are able to create tables and prototypes for people during design meetings.

The use of the platform seems straightforward.

It's easy to use.

I like the way that it automatically goes into the spreadsheets and the users can deal with it.

There is not a lot of Wiki help or in Google, but there is some.

I have been working with Oracle Application Express (APEX) for a year.

We are still on version 5.1. We are trying to upgrade and move to the cloud.

It seems pretty stable.

This is an area of concern, as we are not sure. We have not explored its scalability.

We have the source code in the database and also produce the forms at the same time.

I don't believe that it is a problem. In most of our use cases, we are either going to have small amounts of people and small amounts of data. 

We have many different teams using it in different areas. For example, we have a big glassware ordering team that uses it, a national management team that uses it to schedule groups and managing programs or agricultural programs. There are nine or ten different teams.

I was not a part of the installation, but it is straightforward when deploying the updates.

We have a team of three or four developers and one admin to maintain this solution.

There is a trial version available that can be used free of charge.

I would suggest trying it for free on the web to see how well it works. You start with the free version, which is version 5.,1 and it's really good. Once you download it and implement it, you have the newest version.

I would rate this solution a nine out of ten.

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.

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.

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. 

I have been working with Oracle for around ten years. 

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. 

We have three to five developers using this solution.

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.

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.

Oracle one of the most expensive databases in the world.

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.