Oracle Application Express (APEX) Reviews

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. 

I use the solution for creating a lot of applications and functions. In my company, we need a lot of forms, a lot of queries and a lot of reports, and I must develop these things very fast. Oracle APEX makes it very easy to do fast development. For example, I can quickly build a financial report, a product report and I can use it for quickly creating approval workflows. Oracle APEX helps a great deal with these tasks.

I started to develop all of the reports my company needs in Oracle APEX. Because the APEX product has a lot of features like automating chart and graph creation, depending on what you want to do, you can easily assemble reports. Another thing that is very helpful is the easy creation of forms for approval and approval workflows. For example, when you must get approval from a manager something, you can easily create the form and the manager can receive it a mobile device and you can get approval for anything quickly. It is helpful for speeding along the process of development.

The first feature that I think is very important is that the product is able to safely deploy on the web. You can develop any application and you can share it on the web without any installation by the end client. The second-best option in Oracle APEX is that it is very easy and very fast. You can quickly create forms and reports and in the reports feature there are a lot of options to help complete tasks. In some ways, it is the same as in Microsoft Excel. You can create charts or create almost anything that has the same features as Excel and it will be immediately available for the end client to use it.

In APEX, they changed the layout which is good because in earlier versions it was a little difficult. In Oracle APEX 18 and 19 it is very much improved and I think it is much better for the improvements. Things are easier to use. For example, when I want to change a form field, form button and anything else on a form, the layout of the product now makes it easier. They could continue to make improvements like this.

I think I only have one problem that I can think of with Oracle APEX in the layout. I can create a cool and beautiful layout. But there are times I want to change something, but I only can use CSS and HTML. Sometimes this makes it so I am not able to accomplish what I want exactly. I think it is better to keep changes to the layout in Oracle APEX only, not use any additional things because something might go wrong. It would be nice if APEX supported Java and everything sold with Java capability.

We don't need to use the Oracle technical support because there is a lot of good information in the Oracle APEX forum. We can use the area to resolve the problems that we run into and there is no need to connect to the technical support and wait for a response.

To learn more about APEX, I use websites, a lot of forums and books. I have a lot of books on the internet and I read and use them. On YouTube, there are a lot of videos for learning about Oracle APEX and other Oracle products. It is a good resource.

I remember the first installation and that time the installation was a little difficult and maybe even very complex. But after maybe 10 or 15 installations now, it is very easy because I know the product better. After gaining some experience, it is very easy.

What was a little difficult the first time is that you must create the network on the database. You must create a different tablespace. After installation, you must use the WebLogic server to launch Oracle APEX form. Then you set the web service and then create WebLogic services. There are a lot of steps there and it is a little different and a bit difficult when you have not had the experience.

When creating projects it might take five or six months for a big production. But I have also completed some products in only two weeks of development.

It is very different for different projects. The project that took only two weeks for developing was because of the size of the project. It was small and I only had five or six forms to build. On the big project that took six months for development, it was because there were a lot of forms, a lot of objects and the project was a lot more complicated.

We are doing all the deployment and deployment on our own. I have a team in my company of four people who are experts in Oracle APEX and we help each other. We don't need to seek outside the company.

Even with four in the team, a small project it could be that one person is enough to complete it. Two different projects will not be the same. In my company, I am involved with different departments. I have a database department and development department. I'm in the development department and the use of resources for big projects will depend what has to be done and what expertise is needed. In one big project, I used a five-person team and also needed two DBAs to help them.

In my country I don't pay any license fees for Oracle APEX. Oracle APEX is a free license, but only Oracle APEX. The database and other products you need to go with it have a licensing fee.

As far as additional costs, there are a lot of patches that we needed on the database and I think a lot of additional costs for peripheral things.

I think it's a very good solution for developing web applications. It's very easy to expand the web application and have strong security in the functionality and availability on the Oracle APEX. I think if some company chooses Oracle APEX as a solution, it's a better base for any web development.

On a scale from one to ten, where one is the worst and ten is the best, I would rate APEX as absolutely a 10. When I started to work in my company they solved a lot of problems for creating a small application, a small form for reporting for anything by using Oracle APEX. Now that I use Oracle APEX I think it is the best solution for my development.

I have some hands-on experience with the tool, but it is not too much. I just installed it and used it for my work. I used the tool for an inventory project, and after some research, my company decided to go somewhere else.

The solution's most valuable features stem from the fact that the tool's performance was not bad at all. We wanted to use the tool for faster development because it helps us avoid and omit boilerplate codes.

The product's stability has certain shortcomings, making it an area where improvements are required.

I have experience with Oracle Application Express (APEX).

Stability-wise, I rate the solution a five to six out of ten.

It is a scalable solution.

Around six or seven developers in our company use the product. In my company, we did some research on the tool with the help of our research and development team.

The product's initial setup phase was straightforward. Most Oracle products have a straightforward installation process.

My company doesn't get involved in the tool's deployment phase. My company's project was deployed over Oracle Application Express (APEX).

The product's integration capabilities were okay. I don't have much to say about it.

I don't feel eligible enough to comment on whether I would recommend the product to others.

If other people want the product in some of their projects, they want a solution that can help with fast development and delivery phases while not wanting a very high performance. They can go for Oracle Application Express (APEX) after PoC and MVP to find its suitability.

In my company, we don't use AI with the tool.

The measurable benefits from the use of the product can be seen in areas like SaaS development and SaaS delivery, and I think the features associated with both areas are good in the tool.

I rate the tool a six to seven out of ten.

Oracle Application Express (APEX) works on data automation. For example. We are building a web application that can auto audit or auto perform examinations for different data and just the user doesn't need to do the examination by itself or do the examination manually. This is exactly how the software works.

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. 

I don't need to know how things truly function with them, and I don't need HTML or have front-end understanding; I can just drag and drop and create or customize a web page by myself.

In my opinion, the UI of the entire program is quite complicated for beginners to understand, especially when it comes to finding a different list or, different kinds of features because the features are not really categorized in the same categories. 

Perhaps it is the name of the categories that are different or not exactly straightforward.

The user needs to think about or do more research on the internet to know where exactly the feature is that they are looking for or where they can find it.

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.

Oracle displays an error page to demonstrate the issue.

When compared to Arotech, or PowerApps, they show you the root cause of it at the very least, which is more information provided when it comes to debugging.

In terms of new features, I'd want to see any type of new functionality in the future, or at the very least update the tutorial or user interface.

The only thing I can think of that might be improved is additional information regarding the root cause or more troubleshooting suggestions.

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

I believe that we are using version 2021.

It's definitely not the most recent version since I'm using it through the company's licensing. We are using an older version.

In my opinion, I believe it is stable. I haven't encountered any issues, or anything such as letting us have system errors, problems, or anything else.

I would rate the stability an eight or a nine out of ten.

Oracle Application Express (APEX) is a scalable solution.

It has the flexibility to accept more users.

This solution is used by ten employees of the company. Half of the employees are administrators and the others are users.

The scalability is good.

We want to increase our use in the future, but I'm not sure if I'll remain with Oracle Application Express (APEX) or experiment with alternative forms of software and low-code apps.

Overall, I appreciate the approach, and I enjoy the program. It will definitely be one of the options in this approach in the future.

I have not reached out to technical support.

We are also working with Microsoft Power Apps.

Power App is only for my own use. It's also different, and there are clearly various use cases, however, I designed the procedure to synchronize a list. Basically, I have a list containing all of the product information, such as the product number, name, and date the data was generated and distributed.

I used it to create inventory management to view the current state of the product and then the production line. It has several applications, but I believe the directions of data analysis. 

It provides an overview of the list, and this is its purpose. This is how PowerApps is used.

The initial setup is quite straightforward, especially when connecting to the SQL workshop.

It took at least two months to get everything to function and then run certain operations, In general, I would estimate one to two months to create a basic program.

I had some assistance from some colleagues in my workplace, who have prior expertise, and they have been quite helpful. I have also learned a lot on the Internet, including instructions supplied by APEX websites.

At the time that I had started with this company, they had 15 to 20 employees who had been using this solution.

I am not aware of the pricing. I don't deal with this area.

I conducted research. Apex, Microsoft Power Apps, and others are also good.

It is also a useful program for doing data automation time. Unfortunately, I was not given the authority to pick which program to use.

This solution has been used in the company for a while and they wanted to build the information they had. I am fully dedicated to the program.

Oracle Application Express (APEX) excels in data automation and digitization. 

It also supports Dynamics reports and Dynamics Graphical charts, as well as analytical methods. 

I believe it is good, and it is simple to implement.

You will save a lot of time for developers to develop their use cases, or implement their use cases into the software.

It allows many users to users to use it. I would say it is good software with enough information on the Internet for people to learn.

Just maybe it's not really good for a brand new beginner who doesn't have any programming or software knowledge, it will be a little bit more difficult to speak with Apex, but overall, I think this local platform saved a lot of time for developers or companies to build their customized, management system or customized ERP.

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

The three-point loss is because of the debugging issue that they have, as well as the interface, which is not very straightforward and is not completely understood.

I would call them small supporting applications, so we use them when we need a web UI for certain users to show data from our environment, mainly in operations.

One of the most valuable features is the ability to build very fast data-driven UIs. Also, those UIs are web-based and don't require any deployment on the user side. We try to avoid complex add-ons or additions, so we stick to the standard features that APEX provides. We also use it for some workflows and to present data out of services or databases.

I think version control can be improved, meaning the ability to track what has changed from the previous version of the application and to see it in standard tools like the code repository. I know in the last versions they were working on it, but I haven't seen it yet. 

The product deployment could be easier. 

In the past, I've thought about dockerization, or the ability to deliver the application as a docker container, and establish the production environment in a job. 

What I would love to see is more integration. I would like to see easier integration into active directory authentication. Also, maybe integration of JavaScript frameworks would resolve some issues.

We have been using APEX for at least eight to ten years.

The solution is highly stable and we have had no issues with it. On a scale of one to five, where one is highly stable and five is not, I would rate it as a one. 

The scalability could be improved. It depends on the use cases. We will never use this solution for a productive environment with 500 to 1000 users because this would be a bit difficult in my opinion. I would say that the scalability for small applications is good, but the scalability for big applications is bad.

About 100 to 150 people are currently using the solution at my company.
We are continuously building small applications, but we don't plan to use this solution to make big applications. It's very use case driven. When we get a use case that is not big and it's easy to create a web-based application, then we use this solution. So we may extend our use of the solution, but we do not plan to migrate anything directly to it.

On a scale of one to five, where one is easy and five is complicated, I would rate the initial setup as a four.

We always lose a lot of time with our outsourcing partner because we don't host the service on our own. This takes some time, so to create the concept for us between the different environments and to do implement it, I would say it takes a minimum of five days.

When you have a licensed database in an Oracle environment, APEX is free.

I would tell those considering this tool that if you have an Oracle environment, it's worth taking a look at. If you don't have an Oracle environment in place, it's the wrong tool. Also, I would tell them to stick to the standard functionalities of APEX and not try to extend it with custom code. We learned that if you stick to the standards the application gives you, it's easy to maintain and it's easy to transfer from one developer to another. If you start to create custom code in hidden areas, it's very hard for the next developer to find the code.

I would rate this solution as an eight out of ten.

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.

I use the solution for rapid application development.

The product is fast. It takes less time to go from development to production. It takes just a few minutes. Progressive Web Apps is the best feature of the product. It is helpful both on the cloud and on our mobile devices. The low code aspect of the solution has improved our productivity significantly. The security features have helped our applications to be secure from all dimensions.

There are not many triggers available. The product must provide more triggers.

I have been using the solution for six years.

We had issues with stability earlier when we were using the 19th edition. Now, we are using 23. It is far better than 19. Now, the product is stable. I rate the stability a seven out of ten.

We have 3000 users in our organization. The product is scalable. I rate the scalability an eight out of ten.

The product was easy to deploy.

I rate the pricing a three out of ten. The tool is not expensive.

Earlier, we were using Oracle applications. Now, we are using APEX. I will recommend the solution to others. Overall, I rate the tool an eight out of ten.

I use Oracle APEX to build forms and pages for end users to easily manage customer complaints and perform quick fixes. By providing a user-friendly interface with proper validation, we empower end users to address issues themselves, reducing the need for backend database intervention. APEX has been a highly efficient tool for facilitating user transactions and resolving customer complaints swiftly.

One standout feature of Oracle APEX is its seamless integration with backend procedures, allowing for quick updates without changing the front-end interface. Additionally, dynamic actions streamline user interactions, enabling complex behaviors like button interactions and API calls with ease. These features drastically improve development efficiency by simplifying backend-to-frontend changes and providing extensive customization options through dynamic actions.

One area for improvement in Oracle APEX is its workflow orchestration capabilities. While it excels in forms and reports, handling complex workflows with waiting states and asynchronous responses needs enhancement. Simplifying workflow management to align with modern architecture standards, like in Fusion, would make APEX more robust and user-friendly.

I have been using Oracle APEX for two years.

Comparing Oracle Form Builder to Oracle APEX, the major advantage of APEX is its ease of layout customization and built-in features, making it more user-friendly than Form Builder. In APEX, layout adjustments are simple with pre-built options and HTML functions, while Form Builder requires meticulous coding and often relies on custom PLL files for advanced customization. Additionally, APEX allows seamless execution of PLC code from the backend, unlike Form Builder, where syntax differences complicate the process. Overall, APEX offers a more streamlined and efficient development experience compared to Form Builder.

Setting up Oracle APEX is straightforward and usually requires just a one-time installation. It is often included for free with Oracle Database versions starting from 11c. Despite its availability, many users may not be aware of it. APEX serves as both a development and reporting tool, addressing users' dynamic and regular data needs efficiently. With APEX, we can quickly develop custom reports or interactive grids within minutes, automating processes and saving significant time in development cycles, typically taking just two to three months from requirement gathering to deployment.

I use Oracle APEX for rapid prototyping and deployment. It is the most efficient tool I have used, significantly reducing development time compared to older platforms. With its low-code interface and abundance of features like dynamic actions, APEX simplifies development, especially for those familiar with traditional forms. Its web-based nature and minimal need for customization further enhance its usability. Overall, APEX streamlines the development process and enables quick deployment of applications with minimal coding effort.

The integration capabilities of Oracle APEX are impressive. We have leveraged backend database connections via DB links to interact with multiple databases seamlessly. This allows us to consolidate data from different sources and generate comprehensive reports within a single APEX application. While we haven't fully explored all integration possibilities, APEX supports various functions like JSON files, web services, and REST APIs, offering potential for future integrations, such as with customer compliance systems. 

Overall, I would rate Oracle APEX as an eight out of ten.