Oracle APEX Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
73 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Do you work for this company?

TrustRadius Top Rated for 2019

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-25 of 34)

Glenn Roberts III profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Oracle Application Express is tightly integrated with and thus leverages all the richness and power of the Oracle database - best RDBMS on the planet
  • Promotes declarative Rapid Application Development and thus provides tremendous business value by shortening development cycles
  • Can't think of any - the Application Express development team does a fantastic job adopting and supporting emerging trends with each new release.
  • Requires Oracle RDBMS; i.e., is not portable to other RDBMS platforms. On the surface this may seem like a con but it is as it should be - Oracle database is best RDBMS available and tight integration with Oracle RDBMS promotes creation of reliable performant apps.
Read Glenn Roberts III's full review
Bernhard Fischer-Wasels profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Ideal for quick prototyping
  • Ideal for quick amendments and enlargements
  • Numerous types of pages/regions (forms, lists, reports, diagrams)
  • Oracle JET integration
  • REST
  • Optional Jasper Reports integration (not OOTB)
  • Printing in good shape not so easy.
  • Diagrams, charts need more detailed explanation concerning the SQL queries needed (examples).
  • No more cons.
Read Bernhard Fischer-Wasels's full review
Igor Filko profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Extreme fast application build and production.
  • Single sign-on via multiple authentication sources.
  • Easy to maintain.
  • Easy to administer users.
  • Easy to administer authorizations.
  • Debugging on several layers.
  • Virtually everything is customizable.
  • Better CSS editing (WYSIWYG).
  • integrated URL masking or better integration via ORDS to make URL masking.
  • out-of-the-box ORDS load-balancing.
Read Igor Filko's full review
Boyd Timmerman profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • APEX is incorporated in the database, which gives it better performance then other tools.
  • Fast in implementing changes.
  • Out-of-the-box responsive applications thanks to the universal theme.
  • When you have an highly customized application upgrading can be a pain.
  • Single page applications are hard to build.
Read Boyd Timmerman's full review
Ozren Pestic profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Low code.
  • Runs on all devices.
  • Good charting and representation of data.
  • I can prepare some nice chart in seconds instead of using reports.
  • Trend and performance is visible in a scale from employees to organization.
  • Great productivity.
  • The interactive grid has great potential, but there's a lot of work to be done.
  • The interactive reports and interactive grid should share the same jet charts.
  • Easier integration of JET into APEX.
  • Tree grid.
  • The interactive grid would have easier navigation using the same principles as in interactive reports (filtering) when you navigate from page to page.
  • It would benefit from the possibility to print nice charts from IR or IG.
  • Needs a better choice of tool-tips.
Read Ozren Pestic's full review
Roel Hartman profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Fast development due to the low code approach.
  • Responsive out of the box due to the built-in Universal Theme.
  • Cloud enabled by design. You can build applications only using a web browser.
  • Scalable: if it runs inside the Oracle database, it uses the full power of that database.
  • Free: it is a no-cost option for the Oracle database.
  • It runs everywhere where Oracle runs, from a small (free) XE database on your laptop, to an Exadata machine.
  • The only languages you need to know are SQL and PL/SQL. Some JavaScript and CSS knowledge might be handy but not strictly necessary.
  • Version control. As all metadata is stored in the database, there are no files to store in a GIT or Subversion repository (unless you export from the database).
  • Lock in: you are locked in into the Oracle database, and that's why it is mostly used in an environment where that database is already present.
  • Oracle is not "popular" at the moment, so the average developer is somewhat older than the regular (JavaScript) developer.
Read Roel Hartman's full review
Christian Remy profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy to learn and to understand.
  • Low code. You can create really fast reports with just " SELECT * FROM TABLE".
  • People can work on reports simultaneously.
  • In Excel, you have to send the file via mail to other people and only one person can work it. Sometimes there are more than one version of this file. With Oracle, this does not happen.
  • Sorry but there are still no cons!
Read Christian Remy's full review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy upgrade path from Forms, allowing reuse of code and a low learning curve for Forms developers.
  • Very quick to develop in. Ideal for prototyping or iterative development which is how we usually work.
  • Comes with cross browser and mobile compatibility out of the box.
  • Easy to incorporate other web technologies.
  • Development environment runs straight from a browser. This has proved to be a life saver when issues crop up on a weekend.
  • No built in printing solution for reports.
  • While being low code for many tasks, some web development skill is helpful for anything complex. I frequently need to use Javascript/CSS/HTML.
Read this authenticated review
No photo available
October 23, 2019

Awesome APEX

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Very rapid development of forms and reports.
  • Awesome GUI look and feel.
  • HTML 5 and CSS 3 compliant. The new version 19.2 now supports rest endpoints for forms and reports.
  • Integration with other databases like My SQL, etc.
Read this authenticated review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Manages security well
  • Provides a responsive environment to build apps in
  • Easy connection to database services
  • Manages sessions very well
  • Javascript functionality
  • Mobile app development- more versatility required especially with the display of reports
  • More documentation that is easy to understand
  • More sample apps on configuration of services and authentication schemes
  • Make it easy to customize templates
  • More themes required
Read this authenticated review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Rapid prototyping enables us to develop very fast.
  • Low code allows us to create applications in a declarative way without too much code written.
  • It's free!
  • You need to find ways to fulfill special customer requests that are not built in and a little bit more complex.
  • You need to have a running Oracle Database (possibly licensed if not XE).
Read this authenticated review
Jesse Boring profile photo
February 11, 2019

Oracle Express

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Eliminates the complexity involved with multi-faceted web applications.
  • Oracle Express supports enhanced productivity in low code apps.
  • It requires no complex build scripts to operate.
  • The software supports effortless customization and design.
  • Lack of a native app.
  • Installation time can be improved, it takes a while to download.
Read Jesse Boring's full review
Mathieu Meeuwissen profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Development is done quickly. Any change to the application can be seen immediately. No generation time needed.
  • Compared to Oracle Forms/Designer this saves a lot of time.
  • The use of CSS and javascript to beautify the layout is easy.
  • There is a large community where you can ask questions or read about how other developerS solved certain issues.
  • Also the Oracle APEX team itself can be reached quite easily.
  • They listen carefully to the suggestions of their users.
  • As you have a lot of freedom where to put your code or how you code it, it is important to think well about standarisation.
  • Version control must be done in a separate tool like Subversion.
Read Mathieu Meeuwissen's full review
Federico Shortrede profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It is an easy tool to adopt, which allowed us to replace developments in Oracle Forms in many cases.
  • It is very simple to develop different kinds of analysis, in a faster and more friendly way than running Oracle Reports.
  • It helped us to extend our approval workflow, in order to cope with difficult branches that were hard to solve with the standard workflow.
  • It was possible to develop web applications, to share information and transactions with our commercial partners.
  • Perhaps is our problem, since we haven’t explored it deeply, but I think that a better portability to mobile devices would help the adoption of APEX.
  • Applications weren’t as light as we thought, and we had to move the APEX server to the same data center where our data base was running, due to performance issues. When we started, we supposed that that situation would not be an issue.
  • At least in Argentina and Brazil, you can not find as many programmers with experience in APEX as you can find with other technologies.
Read Federico Shortrede's full review
Katy A. Gray, M.S., PHR profile photo
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Organization - it helps streamline employee information.
  • User-friendly - very simple to use once you are trained on it.
  • Timely - system works quickly and efficiently.
  • Reporting - you have to use a certain code to run reports, and the reports will fail if you don't use the proper coding when requesting them.
  • System crashes - our server goes down once or twice a week.
  • Searching for employees - we can only search by last name, and sometimes it does not recognize the name the first time you enter it.
Read Katy A. Gray, M.S., PHR's full review
Teal Sexton profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Allow you to use data from your Oracle Database to pre-fill forms or reports.
  • It allows you to write data back to the Oracle Database.
  • It is extremely fast! We have over 100 concurrent users in our APEX application and never get complaints about performance.
  • It is highly configurable and can be used to create all kinds of different applications.
  • You can only use APEX if you own Oracle Database.
Read Teal Sexton's full review
Joseph R. Sweeney profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Very easy to create a dashboard-like app platform with minimal coding knowledge.
  • Implementation went off without any issues and the connected systems worked very well.
  • Users can create their own reports very easily.
  • While we were transitioning to more Oracle based services, we did find that APEX was locked to only Oracle products. So if you are not fully committed, it will have limited functionality.
  • No version control and so make sure to keep communication open between developers.
Read Joseph R. Sweeney's full review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It's free: it can be used with the different versions of the ORACLE database including the Express Edition.
  • It has authentication and authorization features within the development environment, which is totally web.
  • High availability in environments with Oracle RAC.
  • Installation and configuration of APEX are simple.
  • No extensive programming experience is required, the interface is very intuitive and there is a lot of information on the web and on the official site of Oracle.
  • It allows exporting interactive reports to different formats: PPT, PDF, HTML, among others. The ability to include graphs for the dashboard simulation is very attractive and quite complete, up to the level of simulating a drill-down, by clicking on a portion of the graph to redirect to a detail table.
  • Developing collaboratively can be a challenge because there is no version at the level of pages or applications.
  • There is an opportunity for improvement in the way data is exported from the interactive report to PowerPoint format.
  • Improve the way to optimize the performance of the application in the database separately from the engine.
Read this authenticated review
No photo available
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Oracle APEX can be used as good replacement for Excel data entry sheets.
  • It provides high level of security about their personal information.
  • It is very easy to install.
  • As it is Oracle-specific, it is not suitable for other databases.
  • Everything is stored online, if there is no internet we can't access the tool.
Read this authenticated review

Feature Scorecard Summary

Visual Modeling (17)
7.5
Drag-and-drop Interfaces (17)
7.7
Platform Security (17)
8.3
Platform User Management (17)
8.6
Reusability (17)
8.6
Platform Scalability (17)
8.4

About Oracle APEX

Oracle Application Express (APEX) Oracle APEX is a free feature of Oracle Database. It's an online low-code application builder that allows users to quickly develop a database-drive application, customize the application's UI, and then give their users access to the application via URL. Oracle APEX includes a suite of pre-built productivity applications and examples, such as a Survey Builder, Bug Tracking, P-Track project management, etc.
Categories:  Low-Code Development

Oracle APEX Technical Details

Operating Systems: Unspecified
Mobile Application:No