Oracle Applications Consultant at ASAM Conseil Inc
Real User
Top 20
You don't need to know how to code because APEX does all of the the coding in the backend, but other solutions have features that APEX doesn't have
Pros and Cons
  • "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."
  • "Maybe there are other technologies that offer what APEX cannot."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

What do I think about the stability of the solution?

APEX is a stable solution.

Buyer's Guide
Oracle Application Express (APEX)
April 2024
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,886 professionals have used our research since 2012.

How was the initial setup?

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

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

The solution is free.

What other advice do I have?

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.

Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
PeerSpot user
Coordinador de inteligencia empresarial at Grupo Orbis
Real User
Rapid deployment, good support, and highly scalable
Pros and Cons
  • "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."

What is our primary use case?

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

What is most valuable?

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

What needs improvement?

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

For how long have I used the solution?

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

What do I think about the scalability of the solution?

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.

How are customer service and support?

The technical support has been good.

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

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.

How was the initial setup?

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

What about the implementation team?

I did the implementation of the solution myself.

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

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

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.

Which other solutions did I evaluate?

We have evaluated other options before choosing Oracle Application Express.

What other advice do I have?

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.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Oracle Application Express (APEX)
April 2024
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,886 professionals have used our research since 2012.
Senior Chief Engineer at ministry of electricity
Real User
We can develop everything locally with it but it doesn't talk with other databases
Pros and Cons
  • "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."
  • "Connecting with Oracle and the relation with Oracle at the database as a procedure needs improvement."

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?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Mehdi Hasankhan - PeerSpot reviewer
Head of Development and Implementation at Arak Petrochemical Company
Real User
Top 5Leaderboard
Powerful development assistance can dramatically speed your production and deployment time
Pros and Cons
  • "This product will speed up development time with helpful production aids."
  • "Being able to only design with HTML and CSS can be limiting as to what can be accomplished."

What is our primary use case?

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.

How has it helped my organization?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

We have been using the solution for six or seven years.

How are customer service and technical support?

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.

How was the initial setup?

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.

What about the implementation team?

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.

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

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.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
IT Developer at Bdl
Real User
Top 20
Fast, secure, affordable, and improves productivity significantly
Pros and Cons
  • "The product is fast."
  • "The product must provide more triggers."

What is our primary use case?

I use the solution for rapid application development.

What is most valuable?

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.

What needs improvement?

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

For how long have I used the solution?

I have been using the solution for six years.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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

How was the initial setup?

The product was easy to deploy.

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

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

What other advice do I have?

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.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Abedulrazag Alkhatib - PeerSpot reviewer
Information Technology Specialist at ARXOS
Real User
Top 10
Powerful, feature-rich, and lets you modernize forms more quickly; it has a good PWA feature
Pros and Cons
  • "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."
  • "Source control could be stronger in Oracle Application Express (APEX). It needs some work."

What is our primary use case?

I'm using Oracle Application Express (APEX) to build a huge application. I'm in the biggest ministry in the Kingdom of Saudi Arabia, and I migrate all the old forms from Oracle Forms 6 to Oracle Application Express (APEX).

What is most valuable?

I like that Oracle Application Express (APEX)has proven itself as a product. It's powerful and attractive, and it allowed my organization to modernize forms within two months, and I'm talking about one thousand five hundred forms.

The ministry here is very impressed with Oracle Application Express (APEX) that it decided to switch to the solution and that even .NET, Java, and Vega will use Oracle Application Express (APEX) versus other solutions.

Oracle Application Express (APEX) is a good platform; others cannot compare to it, especially regarding support, performance, and productivity.

What I found most valuable in the solution is its IDE Cloud because you don't need to do installations in the machines, and you don't need huge specifications.

I also found the PWA feature of Oracle Application Express (APEX) very powerful because you can produce substantial mobile applications, and it's as simple as clicking the built-in authentication, single sign-on LDAP (Active Directory). Because of the built-in features of Oracle Application Express (APEX), it's fantastic.

The solution is feature-rich, and it usually takes months to produce web services, especially group services in .NET or Vega. Still, with Oracle Application Express (APEX), it only takes a few hours, which is a significant improvement for the government here.

Oracle has yearly releases for this solution, three releases a year, so I'm delighted, and I'm expecting more features to be added to Oracle Application Express (APEX) in the future. Right now, it has all the capabilities my organization needs. The solution even lets you build your templates, UI/UX-wise, so I'm working on a project where I make my own UI/UX and theme faster through Oracle Application Express (APEX).

What needs improvement?

I'm satisfied with Oracle Application Express (APEX), but it needs to work on its source control, which is very important. Currently, source control is not as strong in the solution, so it needs some work.

For how long have I used the solution?

I've been using Oracle Application Express (APEX) since 2003.

What do I think about the stability of the solution?

Oracle Application Express (APEX) is a very mature, stable solution.

What do I think about the scalability of the solution?

As Oracle powers Oracle Application Express (APEX), it has high availability and scalability. It has everything you don't usually find in other solutions.

How are customer service and support?

I don't need to contact Oracle Application Express (APEX) technical support because it's a very mature solution. I'm also a leader who knows everything about Oracle Application Express (APEX). My team builds huge applications and has a case management system and a project management module on top of Oracle Application Express (APEX). I've produced many applications using the solution, so my team and I can handle technical issues, if any. The user experience and interface for Oracle Application Express (APEX) are also good, so I don't need support from Oracle.

How was the initial setup?

The initial setup for Oracle Application Express (APEX) is fantastic because you can install or deploy it from the top through Amazon RDS or  CAD. You can deploy the solution quickly. I currently have a project with the ministry to roll out Oracle Application Express (APEX) for fifty-four pluggable databases.

Setting up the solution is smooth, and there's no downtime during deployment. I found its setup excellent.

Deploying Oracle Application Express (APEX) requires taking care of the packages on the databases, as well as publication. It's straightforward.

What about the implementation team?

I'm working on a massive project, so I have a team responsible for implementing Oracle Application Express (APEX). My team is working on making the process more systematic, where you don't need a human. There'll be an engine that takes care of the whole process.

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

Oracle Application Express (APEX) is free, so this is another magic of the solution. You just get charged for the database license, which I don't need.

What other advice do I have?

I'm an expert on Oracle Application Express (APEX).

I'm working with the latest Oracle Application Express (APEX) release.

I have many Oracle Application Express (APEX) projects, with one project deployed on-premises, and another on the cloud, using an autonomous database.

Two people work on the Oracle Application Express (APEX) deployment, which is the magic of this solution because it only requires two people to deploy on a massive project, even with hundreds of CRs. The deployment process is smooth.

Compared to Oracle Forms, Oracle Application Express (APEX) requires eighty percent less maintenance.

The ministry has seven thousand concurrent users working with the solution, with one hundred thousand transactions daily and about sixty thousand reports printed daily.

I would recommend Oracle Application Express (APEX) to others looking into using it one hundred percent. I'd tell you not to go with other tools because there's no comparison between Oracle Application Express (APEX) and its competitors. I have twenty years of experience in development, and I've worked on Java, .NET, Oracle forms, Vega, and low-code developments. I hardly have to work when using Oracle Application Express (APEX). My advice is to choose it over others.

I'm giving Oracle Application Express (APEX) a perfect score of ten. I'm giving it a hundred percent rating.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Oracle Apex Developer at Abu Dhabi City Municipality
Real User
Top 10
Low code, easy to use, and has lots of great features
Pros and Cons
  • "It's stable and reliable for the most part."
  • "There is a bit of a learning curve involved when first using the solution."

What is our primary use case?

We primarily need the solution for our applications. My company needed some workflows for finance and other services in my company. We wanted to integrate with other systems to have everything working together. 

What is most valuable?

It is easy to use.

There are lots of very good features.

The product is low code. You don't need to be an engineer to use it. 

It's stable and reliable for the most part.

What needs improvement?

There is a bit of a learning curve involved when first using the solution.

Sometimes we have low performance if we're trying to get large amounts of data. It's not great with big data.

For how long have I used the solution?

I've been using the solution for five years now. 

What do I think about the stability of the solution?

The stability is good. There are no bugs or glitches. However, we have had some issues around performance and big data. That said, it doesn't creak down. 

What do I think about the scalability of the solution?

We have five people using the solution in our organization. They are developers.

How are customer service and support?

I've never dealt with technical support. I can't speak to how helpful or responsive they are. 

What other advice do I have?

I'd recommend the solution to others. The company should push for it.

Our company is an Oracle partner. 

I would rate it ten out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
Software Developer at Watronix Information Technology Ltd
Real User
Top 20
Connection is quick and simple, but stability could be improved and installation could be simplified
Pros and Cons
  • "A user interface is relatively simple to create."
  • "It would be beneficial to include WebSockets so that you can see real-time updates."

What is our primary use case?

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

We look after the local government and Healthcare.

What is most valuable?

A user interface is relatively simple to create.

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

What needs improvement?

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.

For how long have I used the solution?

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

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

What do I think about the stability of the solution?

Oracle Application Express (APEX) is not very stable.

What do I think about the scalability of the solution?

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.

How are customer service and support?

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

Response time is very slow.

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

I work with multiple solutions simultaneously.

How was the initial setup?

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.

What about the implementation team?

Our in-house team completed the deployment.

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

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.

Which other solutions did I evaluate?

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

What other advice do I have?

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.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Oracle Application Express (APEX) Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Buyer's Guide
Download our free Oracle Application Express (APEX) Report and get advice and tips from experienced pros sharing their opinions.